How to insert Symbol Ampersand into ButtonName in VBA

[marimar02]

Hello,

How can I insert a "&" symbol into the text of a ButtonName dialog?. My formula is set to name the button but when displayed, "P&L" becomes "PL". Here is part of the formula that I need to edit. Do I use CHAR function?

fDialog.ButtonName = "Upload selected P&L file"

Thanks for your help...

 

[skywriter]

Just a quick suggestion, don't know if it will work, but maybe put the ampersand in separate quotes "&" maybe "P"&"&"&"L", see if that works.

 

[Br0ck]

Try it with 2. "P&&L"

 

[marimar02]

Thank you Skywriter. I tried that as well but didn't work.

 

[marimar02]

Thanks BrOck. I tried it and didn't work for me. Still says PL.

 

[skywriter]

Hello,

How can I insert a "&" symbol into the text of a ButtonName dialog?. My formula is set to name the button but when displayed, "P&L" becomes "PL". Here is part of the formula that I need to edit. Do I use CHAR function?

fDialog.ButtonName = "Upload selected P&L file"

Thanks for your help...

Well I don't know if you tried it yet. It's chr(38)

So I guess:
"Upload selected P"& Chr(38) & "L file"

 

[marimar02]

Well I don't know if you tried it yet. It's chr(38)

So I guess:
"Upload selected P"& Chr(38) & "L file"

Hmmmm. That did not do the trick. Still get the "PL"

fDialog.ButtonName = "Upload selected P" & Chr(38) & "L file"