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.

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" <(E-Mail Removed)> wrote in message
news:8941C64B-514C-4EF3-9829-(E-Mail Removed)...
>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.

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