ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Toolbar/Menu for UserForm (https://www.excelbanter.com/excel-programming/391645-custom-toolbar-menu-userform.html)

mikeg710

Custom Toolbar/Menu for UserForm
 
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?

Tom Ogilvy

Custom Toolbar/Menu for UserForm
 
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?


mikeg710

Custom Toolbar/Menu for UserForm
 
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?


Peter T

Custom Toolbar/Menu for UserForm
 
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" wrote in message
...
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?





All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com