How to run two button macros with one button?

Geza59 · #1 02-12-2013, 07:47 AM

Hi again!

I have a macro "CommandButton2_Click" assigned to a button a Sheet1
that can output the current date and time to a text file.

Another button on Sheet2 ("CommandButton4_Click") outputs the required data to the same text file.

So, how can I modify the 2nd macro, so that it will also export the date and time before exporting the required data to the text file?

I tried to use "Call" with the 2nd macro like this:

Code:

Private Sub CommandButton4_Click()

     Call Sheet1.CommandButton2_Click

     Dim FileName As String  ' the file to write to
     Dim DataRange As Range  ' the range containing the data to export
     Dim Append As Boolean   ' whether to append or overwrite existing data
etc.

     End If


End Sub

macropod · #2 02-14-2013, 12:11 AM

I'd put the code used by CommandButton2 into a separate sub, probably in a general code module, and have both CommandButtons reference that sub. The alternative is to have the same piece of code attached to both CommandButtons.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting Macro Button	mata30s	Word VBA	0	01-23-2013 12:04 PM
Command Button	cksm4	Word VBA	7	02-27-2011 08:47 PM
Macro Button	B2W	Excel	2	06-18-2010 09:36 AM
calling images with a button	sammer021486	PowerPoint	0	01-13-2010 08:24 AM
Help on option button active X	aligahk06	Excel	0	11-03-2009 11:39 PM