I am developing a custom dialog box/userform through the Excel 2003 VBE. I
would like to create a custom toolbar menu for this userform, but I can't
find any controls that allow me to "build" a toolbar in the VBE.

Is there a way to do this with the VBE, or must it be coded using VBA?

Userforms don't support menus like VB 6.0 forms. At least there is no built
in support for it - no controls.

--
Regards,
Tom Ogilvy



"mikeg710" wrote:

> I am developing a custom dialog box/userform through the Excel 2003 VBE. I
> would like to create a custom toolbar menu for this userform, but I can't
> find any controls that allow me to "build" a toolbar in the VBE.
>
> Is there a way to do this with the VBE, or must it be coded using VBA?

Thank you.

"Tom Ogilvy" wrote:

> Userforms don't support menus like VB 6.0 forms. At least there is no built
> in support for it - no controls.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "mikeg710" wrote:
>
> > I am developing a custom dialog box/userform through the Excel 2003 VBE. I
> > would like to create a custom toolbar menu for this userform, but I can't
> > find any controls that allow me to "build" a toolbar in the VBE.
> >
> > Is there a way to do this with the VBE, or must it be coded using VBA?

You could try the TabStrip. You might need to add 'MS Forms 2.0 TabStrip' to
your Control-toolbox.

If you set Appearance-0 and Style-0 (in the Custom properties), add some
buttons and it'll look pretty much like a menu bar.

Regards,
Peter T



"mikeg710" <(E-Mail Removed)> wrote in message
news:60C931C3-77AF-440C-8035-(E-Mail Removed)...
> I am developing a custom dialog box/userform through the Excel 2003 VBE.
I
> would like to create a custom toolbar menu for this userform, but I can't
> find any controls that allow me to "build" a toolbar in the VBE.
>
> Is there a way to do this with the VBE, or must it be coded using VBA?