top menu bar in userforms?

[jonn]

Is there a built vba function for this as with visaul basic?

[royUK]

Unfortunately not

[dominicb]

Good evening

Ivan F Moala has achieved this by using the scariest API's imaginable to create true top level Windows menus within a userform. Normally, I would advise people to avoid this sort of thing, however, he has very kindly written a wrapper routine so that normal people like us can utilise his hard work. Read up on it here :

http://www.xcelfiles.com/API_Userform_MenuMaker.html

However, as Ivan himself points out there is little error checking in his routine and if something bombs out while you're working on APIs don't be surprised if a total reboot is necessary. Back up and save often is the key here ...

HTH

DominicB