JKwan
05-28-2007, 07:10 AM
I created a Meue Bar with the following button:
With bar.Controls.Add(Type:=msoControlButton)
.FaceId = 384
.Caption = "Get Stock Quotes"
.Style = msoButtonIconAndCaption
.OnAction = "GetStockData" & " False" <----- Problem here
End With
Now, I started to monkey around with the Procedural call. I wanted to pass in an Optional parameter of Boolean type. Of course, it is not working very well. What is the syntax? Is this possible with the Command Bar?
Thanks
With bar.Controls.Add(Type:=msoControlButton)
.FaceId = 384
.Caption = "Get Stock Quotes"
.Style = msoButtonIconAndCaption
.OnAction = "GetStockData" & " False" <----- Problem here
End With
Now, I started to monkey around with the Procedural call. I wanted to pass in an Optional parameter of Boolean type. Of course, it is not working very well. What is the syntax? Is this possible with the Command Bar?
Thanks