Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I list Ampersand in a caption or quotes? -- & in " "
My code creates an excel bar. I want the ampersand character in the
tooltip text and/or caption depending on the button. But Excel only shows extra spaces or duplicates a word and acts funny. I know special characters usually require something or they don't display as text. Help? '<<--Button 5 User Mode ' Create a button with an image on the bar and set some ' properties. Set ComBarContrl = ComBar.Controls.Add(Type:=msoControlButton) With ComBarContrl 'the facId line will let you choose an icon ' If you choose to use the faceId then the caption is not displayed .FaceId = 3059 .Style = msoButtonIconAndCaption .Caption = "User Mode" .TooltipText = "Lock & Hide Sheets for User Mode" 'the onaction line tells the button to run a certain marcro .OnAction = "btnUserMode.HideAllButOneSheet" End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I list Ampersand in a caption or quotes? -- & in " "
Try
..TooltipText = "Lock && Hide Sheets for User Mode" If this post helps click Yes --------------- Jacob Skaria "Benjamin" wrote: My code creates an excel bar. I want the ampersand character in the tooltip text and/or caption depending on the button. But Excel only shows extra spaces or duplicates a word and acts funny. I know special characters usually require something or they don't display as text. Help? '<<--Button 5 User Mode ' Create a button with an image on the bar and set some ' properties. Set ComBarContrl = ComBar.Controls.Add(Type:=msoControlButton) With ComBarContrl 'the facId line will let you choose an icon ' If you choose to use the faceId then the caption is not displayed .FaceId = 3059 .Style = msoButtonIconAndCaption .Caption = "User Mode" .TooltipText = "Lock & Hide Sheets for User Mode" 'the onaction line tells the button to run a certain marcro .OnAction = "btnUserMode.HideAllButOneSheet" End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
MSN stock quotes - Error message "problem displaying attributes" | Excel Discussion (Misc queries) | |||
how can I use the ampersand in a custom header as the word "and"? | Excel Discussion (Misc queries) | |||
How do I display the "ampersand" in the header as text | Setting up and Configuration of Excel |