userform comments

[Trefor]

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.

 

[Bob Phillips]

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)

 

[Tim]

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

 

[Tim]

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

 

[Trefor]

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

 

[Trefor]

Bob,

Excellent, just what the doctor ordered

Many thanks.