Create a floating tool bar.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TUNGANA KURMA RAJU - 28 May 2008 13:54 GMT

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.

Reply to this Message

Bernie Deitrick - 28 May 2008 16:53 GMT

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

>I am very much new to write vba.
> 1.I am having a macro,results of which should refelect in a toolbar list( or
[quoted text clipped - 5 lines]
> If both are possible ,kindly give me Vba code and other set up details to do
> the above 2 tasks.

Reply to this Message

Dave Peterson - 28 May 2008 18:26 GMT

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.

> I am very much new to write vba.
> 1.I am having a macro,results of which should refelect in a toolbar list( or
[quoted text clipped - 5 lines]
> If both are possible ,kindly give me Vba code and other set up details to do
> the above 2 tasks.

Signature

Dave Peterson

Reply to this Message