Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Tool Bar
Would someone tell me how to modify the List command tool-bar? I would like
to add a Command Button to the "Form" which displays upon selecting Form in the List command bar menu option drop-down. This Form dynamically creates fields for the selected cells in a worksheet. I would like to extend the functionality a bit further. Where do you start when accessing the programming of the built-in toolbars? thx, Ted |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Tool Bar
Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://support.microsoft.com/default...b;en-us;166755 File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R) Excel 97 File Name: WE1183.EXE File Size: 58041 bytes File Date: 06/20/97 Keywords: kbfile kbappnote Description: This Application Note can help you learn techniques for writing Visual Basic(R) for Applications code to customize menus in Microsoft Excel 97. This Application Note contains code examples that you can use with the following elements: menu bars, menus, menu items, submenus, and shortcut menus. -- Regards, Tom Ogilvy "Ted" wrote in message ... Would someone tell me how to modify the List command tool-bar? I would like to add a Command Button to the "Form" which displays upon selecting Form in the List command bar menu option drop-down. This Form dynamically creates fields for the selected cells in a worksheet. I would like to extend the functionality a bit further. Where do you start when accessing the programming of the built-in toolbars? thx, Ted |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Tool Bar
Thanks, Tom this is what I've been looking for.
"Ted" wrote: Would someone tell me how to modify the List command tool-bar? I would like to add a Command Button to the "Form" which displays upon selecting Form in the List command bar menu option drop-down. This Form dynamically creates fields for the selected cells in a worksheet. I would like to extend the functionality a bit further. Where do you start when accessing the programming of the built-in toolbars? thx, Ted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
has anyone have an excel tool inventory list template | Excel Discussion (Misc queries) | |||
List Box in Control Tool Bar | Excel Discussion (Misc queries) | |||
What happened to Scenarios tool (drop-down list)? | Excel Discussion (Misc queries) | |||
List box in tool bar | Excel Discussion (Misc queries) | |||
How do I create a list when it is not in the Data tool bar? | Excel Discussion (Misc queries) |