command button
 

Need Hellllllp!!

I'm a novice excell user and would like to create one command button to run
various functions in 4 different cells. In other words I would like to type
in the values in the 4 cells then hit my command button to run the various
functions that follow..... I have created the button in my wrk sheet but I
have never used visual basic before and use some help...been at it all night
and gotten no where.

Anything will be a great deal of help


Nate...El Paso tx

command button
 

Hi Nate

Not really sure what you are asking here, do you have your functions
already written? if so you can place them in a module and call them
when you click the button. to do this you will need to open the
visual basic editor from under the Macro option of the Tools -menu or
ALT + F11.

From here Insert a module and put code in it to call your functions
and then assign that sub to your button then when you click the button
it will run your functions, to do that right click on your button
while in Design Mode and select the assign Macro option. this loads
the Asign Macro window where you shoul dbe able to see the name of
your Sub in the list select it and click OK and thats it. i have
given a code example below

Option Explicit

Sub RunMyFunctions()

'replace the MyFunction title with the name of the function
'you want to run i.e. your function is called ResizeRange
'you would write Call ResizeRange

Call MyFunction
Call MyFunction1
Call MyFunction2
Call MyFunction3

End Sub

Function MyFunction()
MsgBox "First Function"
End Function
Function MyFunction1()
MsgBox "Second Function"
End Function
Function MyFunction2()
MsgBox "Third Function"
End Function
Function MyFunction3()
MsgBox "Fourth Function"
End Function

hope this helps

Steve