Comment on userform

Hello Guys,

plz need your help, i wanna show a comment when i cross a textBox, ComboBox or ... in a userform. How would i do that ?

Thank you it is urgent

Hi,

I'm not sure I completely understand what you need. Do you simply wish to add a comment to a cell that indicates what user it was left by?

Thanks.

thanks for answering, but what i need is to show a comment wish explain smth about the cell so that the user doesn't write smth wrong.

For exemple if my cell has to have a number% btw (2% to 4%) the user has to write a number in btw. and the message will be when i cross that cell " the rate of bla bla is btw 2% and 4% "

Ok, look at the sample excel sheet I attached. If you scroll over the yellow squares, you'll see a comment box pop up. Is this what you are referring to?

yes exactly what i need but in a textbox or comboBox in a userform thank you

Here is what I was able to find. I have Excel 2010 so it isn't exactly like 2007. But this should help.

http://www.youtube.com/watch?v=AWWKAWttuiU

oh this video is not about adding comment anyway i found the solution u have to use this method

Private Sub Userform_Activate()

TextBox1.ControlTipText = "bla bla bla"

end sub

This is the code of how it works.

Thank you Brother

You're welcome Sister.