ExcelBanter - How do I embed a commandbutton from VisualBasic into Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I embed a commandbutton from VisualBasic into Excel (https://www.excelbanter.com/excel-programming/336768-how-do-i-embed-commandbutton-visualbasic-into-excel.html)

SIDAS

How do I embed a commandbutton from VisualBasic into Excel

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

Norman Jones

How do I embed a commandbutton from VisualBasic into Excel

Hi Sidas,

Try:

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

---
Regards,
Norman

"SIDAS" wrote in message
...
Programming usig Macros. Would like to embed a commandbutton from
VisualBasic
into Excel version 2002.

All times are GMT +1. The time now is 08:58 PM.