I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

When designing your UserForm, click the button you want. In the Properties
Window (press F4 if not displayed), go to Control Tip Text. Type in the text
you want. I just learned that a month ago, and I use it whenever I can.

"Roger on Excel" wrote:

I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

What type of button is it, forms or Control toolbox?

--
__________________________________
HTH

Bob

"Roger on Excel" wrote in message
...
I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is
highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

I just -re-read the original post, and I didn't realize that your button was
on the spreadsheet. If it is a Control Toolbox, then what I said should work.
I don't know if the same will hold true if you used the Forms button.

"Bob Phillips" wrote:

What type of button is it, forms or Control toolbox?

--
__________________________________
HTH

Bob

"Roger on Excel" wrote in message
...
I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is
highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

Hi,

Yes its a floating button on the spreadsheet. Can these have a tolltip added
to them?

Thanks for the advice regarding buttons on forms - ive added tool tips for
the buttons on those forms.

Thanlks, Roger

"Orion Cochrane" wrote:

I just -re-read the original post, and I didn't realize that your button was
on the spreadsheet. If it is a Control Toolbox, then what I said should work.
I don't know if the same will hold true if you used the Forms button.

"Bob Phillips" wrote:

What type of button is it, forms or Control toolbox?

--
__________________________________
HTH

Bob

"Roger on Excel" wrote in message
...
I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is
highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

Floating? Do you mean a commandbar button? If so, just add to the
ToolTipText property.

--
__________________________________
HTH

Bob

"Roger on Excel" wrote in message
...
Hi,

Yes its a floating button on the spreadsheet. Can these have a tolltip
added
to them?

Thanks for the advice regarding buttons on forms - ive added tool tips for
the buttons on those forms.

Thanlks, Roger

"Orion Cochrane" wrote:

I just -re-read the original post, and I didn't realize that your button
was
on the spreadsheet. If it is a Control Toolbox, then what I said should
work.
I don't know if the same will hold true if you used the Forms button.

"Bob Phillips" wrote:

What type of button is it, forms or Control toolbox?

--
__________________________________
HTH

Bob

"Roger on Excel" wrote in
message
...
I have buttons which access macros in my spreadsheet (xl2003).

Is there a way to add a comment (like a tool tip) so that it is
highlighted
as the mouse passes over the button.

I want to add guidance notes as to the use of the buttons.

Can anyone help?

Thanks,

Roger

Hi Bob,

The button is one that sits in the spreadsheet. I placed it using the Forms
Toolbar, using the "button" button.

I assigned the macro to the button. I dont think the button has a properties
window.

What do you think?

Roger

"Bob Phillips" wrote:

Floating? Do you mean a commandbar button? If so, just add to the
ToolTipText property.