Is it possible to pint and click from with VBA
 

Hello

Is it at all possible to point and click toolbar for within Excel VBA.
This is for a commercial Excel add-in application (don't have access the
VBA program). What I want to do is activate these functions from within
my own Userform.

Thaks
K

Is it possible to pint and click from with VBA
 

Not point and click, but if it is a VBA add-in, you could try this

With Application.CommandBars("Standard").Controls("xxx" )
Application.Run .OnAction
End With

where xxx is the toolbar button caption

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kurb" wrote in message
. ..
Hello

Is it at all possible to point and click toolbar for within Excel VBA.
This is for a commercial Excel add-in application (don't have access the
VBA program). What I want to do is activate these functions from within
my own Userform.

Thaks
K

Is it possible to pint and click from with VBA
 

Thank you for your response.

Is there a way to get the Macro to create the coding for a series of
mouse actions (like can be done for Excel functions) ?

Thanks
K


Bob Phillips wrote:

Not point and click, but if it is a VBA add-in, you could try this

With Application.CommandBars("Standard").Controls("xxx" )
Application.Run .OnAction
End With

where xxx is the toolbar button caption