Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform comments
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming |