PDA

View Full Version : Using Office.CommandBar



Rasm
12-01-2011, 07:21 AM
I am trying to use Office.CommandBar - I have it on a userform - that is shown as VbModeLess. It works fine when I Activate the userfrom - However I have another userform running as well - so when the other has focus and I now go back to the one with the Office.CommandBar - I get an error.

I am wondering if somebody has a good example of how best to use Office.CommandBar when switching between userforms and both userforms are loaded.
Thanks
Rasm

Excel Fox
12-02-2011, 10:06 PM
Rasm, can you post this file? Seems it would be easier to comprehend the situation if you had those two forms visible

Rasm
12-03-2011, 06:04 AM
Fox
I have moved the code into a separate xlsm file - But I cannot reproduce the error in a consistent fashion - it happens but in an erractic way. So until I can reproduce the problem - you cannot do anything - unless you can see me doing something silly.
Thanks
Rasm