ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List Tool Bar (https://www.excelbanter.com/excel-programming/318116-list-tool-bar.html)

Ted

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

Tom Ogilvy

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




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