Passing Variable with .OnAction

[Opv]

Can someone please advise if there is a way to pass a variable with the .OnAction line? The following does not seem to work.

[VBA]
With .Controls.Add(Type:=msoControlButton)
.Caption = "Auction View"
.FaceId = 384
.OnAction = "createView(""auctionView"")"
.Width = myIconWidth
[/VBA]

[GTO]

Presuming that "Auction View" is a string, not tested, try:
[vba]
.OnAction = "'createView ""auctionView""'"
[/vba]
Please carefully note that there are single quotes on the inner-side of the outermost double-quotes.

[GTO]

Here is an article by Tushar Mehta:

http://www.tushar-mehta.com/excel/vb...0arguments.htm

[Opv]

Presuming that "Auction View" is a string, not tested, try:
[vba]
.OnAction = "'createView ""auctionView""'"
[/vba] Please carefully note that there are single quotes on the inner-side of the outermost double-quotes.

Thanks. That seems to have done the trick...at last as far as I can tell now. At least it's calling the appropriate subroutine. Still got a problem with functionality in that sub but I think I can tinker with it and get it working right. I'm going to leave this thread open for now just in case I run into a snag.

Thanks again,

Opv

[Opv]

Here is an article by Tushar Mehta:

http://www.tushar-mehta.com/excel/vb...0arguments.htm

Thanks.