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.