How do I embed a commandbutton from VisualBasic into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Programming usig Macros. Would like to embed a commandbutton from VisualBasic
into Excel version 2002.
 
Hi Sidas,

Try:

ActiveSheet.OLEObjects.Add ClassType:= _
"Forms.CommandButton.1"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcut key to commandbutton 3
IS it possible to add Hyperlink to a commandbutton on a Userform 9
Adding a commandbutton in Excel 2003 5
Hyperlink in Commandbutton 4
commandbuttons won't trigger code. 10
Using a variable to select a CommandButton and setting the caption 4
Help with CommandButton vs Excel 2002 2
Size of CommandButton changing while not expected ! 1

Back
Top