ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delete combobox (https://www.excelbanter.com/excel-programming/320438-delete-combobox.html)

Roman Töngi

delete combobox
 
How can I delete a combobox placed in a worksheet by VBA, after
I no longer need it? Or can it be hidden? But it has no visible-property.

Best wishes Roman
Excel 2002



Tom Ogilvy

delete combobox
 
worksheets("Sheet1").OleObjects("Combobox1").Delet e

or

worksheets("Sheet1").OleObjects("Combobox1").Visib le = False

--
Regards,
Tom Ogilvy

"Roman Töngi" wrote in message
...
How can I delete a combobox placed in a worksheet by VBA, after
I no longer need it? Or can it be hidden? But it has no visible-property.

Best wishes Roman
Excel 2002





Roman Töngi

delete combobox
 
thanks




All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com