Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a floating tool bar.
I am very much new to write vba.
1.I am having a macro,results of which should refelect in a toolbar list( or in a fully opened combo box toolbar).How to create a floating toolbar(commandBar),and display it whenever my w/book opens and closes everytime imy w/book closes. 2.Alternately,if the said macro results can be dispalyed in a msg.box,whenever w/book opens? If both are possible ,kindly give me Vba code and other set up details to do the above 2 tasks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a floating tool bar.
TUNGANA KURMA RAJU,
In the codemodule of the Thisworkbook object, use code like Private Sub Workbook_Open() Dim strResult 'Calculate result strResult = Format(Worksheets(1).Range("A1").Value, "000.000") MsgBox "The result is " & strResult End Sub HTH, Bernie MS Excel MVP "TUNGANA KURMA RAJU" wrote in message ... I am very much new to write vba. 1.I am having a macro,results of which should refelect in a toolbar list( or in a fully opened combo box toolbar).How to create a floating toolbar(commandBar),and display it whenever my w/book opens and closes everytime imy w/book closes. 2.Alternately,if the said macro results can be dispalyed in a msg.box,whenever w/book opens? If both are possible ,kindly give me Vba code and other set up details to do the above 2 tasks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a floating tool bar.
For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. TUNGANA KURMA RAJU wrote: I am very much new to write vba. 1.I am having a macro,results of which should refelect in a toolbar list( or in a fully opened combo box toolbar).How to create a floating toolbar(commandBar),and display it whenever my w/book opens and closes everytime imy w/book closes. 2.Alternately,if the said macro results can be dispalyed in a msg.box,whenever w/book opens? If both are possible ,kindly give me Vba code and other set up details to do the above 2 tasks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a floating column? | Excel Worksheet Functions | |||
Create a floating calender | Excel Programming | |||
how do you create a floating row? | Excel Worksheet Functions | |||
UserForm as a tool bar/ floating options for excel sheet | Excel Programming | |||
How can I create a Floating Command Button | Excel Programming |