![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com