I am trying to add a tool tip to a command button.

Set SandP = ActiveSheet.Buttons.Add(400, 15, 107.75, 47.25)
SandP.OnAction = "SandP_Click"
SandP.Caption = "Sort and Print"
SandP.ControlTipText = "Blah Blah Blah"

This does not seem to work. Any thoughts?

Thank you

SS

SS,

Control Toolbox controls do not support tooltips, but they can be achieved
with a bit of tweaking.

If you want to mail me directly, I can send you a sample of the technique.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"SS" wrote in message
...
I am trying to add a tool tip to a command button.

Set SandP = ActiveSheet.Buttons.Add(400, 15, 107.75, 47.25)
SandP.OnAction = "SandP_Click"
SandP.Caption = "Sort and Print"
SandP.ControlTipText = "Blah Blah Blah"

This does not seem to work. Any thoughts?

Thank you

SS

Email sent. Thank you.

-----Original Message-----
SS,

Control Toolbox controls do not support tooltips, but
they can be achieved
with a bit of tweaking.

If you want to mail me directly, I can send you a sample
of the technique.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"SS" wrote in
message
...
I am trying to add a tool tip to a command button.

Set SandP = ActiveSheet.Buttons.Add(400, 15, 107.75,
47.25)
SandP.OnAction = "SandP_Click"
SandP.Caption = "Sort and Print"
SandP.ControlTipText = "Blah Blah Blah"

This does not seem to work. Any thoughts?

Thank you

SS


.