To be able to add a comment to a cell is a great feature, but is it possible
to do something similar on a Userform? I would like to be able to get help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor

There is a property for most controls called ControlTipText that does just
that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Trefor" wrote in message
...
To be able to add a comment to a cell is a great feature, but is it
possible
to do something similar on a Userform? I would like to be able to get help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor

Trefor,

I've done this before by having a textbox at the bottom of the form... use
the mouse movement properties (can't remember their names) of the control
you're hovering over to change the text in the 'comment' textbox (then empty
it when you move away)

Tim


"Trefor" wrote in message
...
To be able to add a comment to a cell is a great feature, but is it
possible
to do something similar on a Userform? I would like to be able to get help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor

Bob's solution is (unsurprisingly) much better than mine... listen to Bob

"Tim" <tmarsh-trousers-@-take off my trousers to reply-blueyonder.co.uk
wrote in message ...
Trefor,

I've done this before by having a textbox at the bottom of the form... use
the mouse movement properties (can't remember their names) of the control
you're hovering over to change the text in the 'comment' textbox (then
empty it when you move away)

Tim


"Trefor" wrote in message
...
To be able to add a comment to a cell is a great feature, but is it
possible
to do something similar on a Userform? I would like to be able to get
help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor

Thanks for the feedback, but Bob's reply was spot on ;)

--
Trefor


"Tim" wrote:

Bob's solution is (unsurprisingly) much better than mine... listen to Bob

"Tim" <tmarsh-trousers-@-take off my trousers to reply-blueyonder.co.uk
wrote in message ...
Trefor,

I've done this before by having a textbox at the bottom of the form... use
the mouse movement properties (can't remember their names) of the control
you're hovering over to change the text in the 'comment' textbox (then
empty it when you move away)

Tim


"Trefor" wrote in message
...
To be able to add a comment to a cell is a great feature, but is it
possible
to do something similar on a Userform? I would like to be able to get
help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor

Bob,

Excellent, just what the doctor ordered ;)

Many thanks.

--
Trefor


"Bob Phillips" wrote:

There is a property for most controls called ControlTipText that does just
that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Trefor" wrote in message
...
To be able to add a comment to a cell is a great feature, but is it
possible
to do something similar on a Userform? I would like to be able to get help
(or comments) when the user moves over a field (text box) on a Userform.

--
Trefor