invoke a function

[Guest]

I need to invoke a function(fx) once a user clicks on button1
ex. Application.Worksheetfinction.CountA -- Is this correct?
Thanks...

 

[Tom Ogilvy]

assume button1 is a commandbutton named CommandButton1. Then double click
on it in design mode to be taken to the click event

Private Sub Commandbutton1_click()

End Sub

Put in your function there

Private Sub Commandbutton1_click()
msgbox "Count is " & _
application.WorksheetFunction.CountA(Selection)
End Sub

 

[Guest]

Tom, what if i just want the function to pop up without a selection range.
Ex. I just want the "Solver" to come up on the screen?

 

[Tom Ogilvy]

If solver is loaded

Private Sub commandButton1_Click()
CommandBars("Tools").Controls("Sol&ver...").Execute
End Sub

Note that Solver is an addin - not a worksheet function. If you create a
reference to it in the VBE, you can look at it properties and methods in the
Object browser.


http://support.microsoft.com/support/excel/content/solver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver


http://www.solver.com/