How do I add a menu bar to an Excel form?

[Paul S. Natanson]

How do I add a menu bar (sometimes also known as a command bar) to an Excel
form?

The controls tool-box in my VBA editor does not have a menu bar control.

When I click right click on my toolbox, I get an option for additional
controls. But the list is so long, that I don't know which one might
contain a menu bar. Can anyone out there tell me where the menu bar control
is?

How do I add a menu bar control to my toolbox?

Paul S. Natanson (e-mail address removed)

(For my real email address, just remove the xxx's.)

Phone +1-908-630-0406 (9 AM - 9 PM eastern USA time)

March 18, 2004

 

[Bob Phillips]

Paul,

VBA userforms do not support menubars, unlike VB forms, I am afraid.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul S. Natanson" <[email protected] (Remove xxx's for real
address.)> wrote in message news:[email protected]...