ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CommandBarControl, Exists??? (https://www.excelbanter.com/excel-programming/298424-commandbarcontrol-exists.html)

Juan[_3_]

CommandBarControl, Exists???
 
Hi All!

Does anyone knows how to check if a given
commandbarcontrol exists and maybe analyze it with a
boolean var???

I want to check for CommandBars(1).Controls
("Tools").Controls("My Personal Tools")

If it exists use it and add a control inside, if not,
creat it....then add a control...

Any help is greatly appreciated...

Regards
Juan

Frank Kabel

CommandBarControl, Exists???
 
Hi
try something like the following

Dim ctrl
on error resume next
set ctrl = CommandBars(1).Controls("Tools").Controls("My Personal
Tools")
on error goto 0
if ctrl is nothing then
msgbox "Control does not exist"
end if


--
Regards
Frank Kabel
Frankfurt, Germany

"Juan" schrieb im Newsbeitrag
...
Hi All!

Does anyone knows how to check if a given
commandbarcontrol exists and maybe analyze it with a
boolean var???

I want to check for CommandBars(1).Controls
("Tools").Controls("My Personal Tools")

If it exists use it and add a control inside, if not,
creat it....then add a control...

Any help is greatly appreciated...

Regards
Juan




All times are GMT +1. The time now is 08:52 AM.

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