View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Dim as CommandBar Does not Work

correction - I forgot to use the vbModeless argument


Userform1.show vbModeless
Application.Wait(Now + TimeValue("0:00:10"))
Unload Userform1

--
Regards,
Tom Ogilvy

"Omar" wrote in message
...
Hi there,

I'm trying to add a new menubar with menu items and i was trying to use

one
of the procedures that I found in Excel 2002 VBA but it does not seem to

work
for some reason. In that procedure you should define one of your

variables
as command bar:

dim xxx as CommandBar

And for some reason it does not seem to work with me, VBA does not seem to
recognize the CommandBar type of objects.

Does this mean that I have incomplete installation of VBA or there is a

bug
with Office 2003 that I'm using. Or, microsofy has deleted CommandBar

type
of objects from its VBA code.

Can anybody help me with that.

Regards