Using VBA to create an ActiveX button

[Phantek]

I am new to VBA so my apologies for my lack of terminology.

As I understand it, there are two types of buttons that can be used in Excel. It is also my understanding that an ActiveX button is what I need as I need to dynamically change properties on the button, such as making it disappear/reappear.

Is there a way to use VBA code to create an ActiveX command button? I am able to use VBA to create a form button, but that does not have all of the functionality that I need. Is there a way to specifically make an ActiveX button from VBA code?

Of course, I may be confused here - please advise if a form button is all I need in this situation.

Thanks in advance for your help!

 

[venkat1926]

suggest RECORD a macro by followings steps to open controlbox button including some change of properties and see the code.

 

[Richard Schollar]

See this thread:
http://www.mrexcel.com/forum/showthread.php?p=1381632

Where the clever Mr Poulsom demonstrates how to add control toolbox controls at runtime and also how to generate event code for them.

 

[Phantek]

Nice - that was what I needed... just a better management of the event code.

Thanks!