Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandBarControl object | Excel Discussion (Misc queries) | |||
A value exists in a list? | Excel Discussion (Misc queries) | |||
File Exists | Excel Discussion (Misc queries) | |||
Worksheet Exists... | Excel Programming | |||
CommandBarControl class | Excel Programming |