How to have a 'comment box' on a user form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pschmidt - 20 Mar 2006 15:54 GMT

How can I create a comment like box (like cell comment) on a user form. If a
user enters an area, this box shows up - no header, etc.

Is this possible??

Thx,

Perry

Reply to this Message

funkymonkUK - 20 Mar 2006 16:33 GMT

i take it you using VBE. if you go on to your userform and then selec
the control you want to change. Say for example you have a norma
userform with one textbox. The textbox comment must say "please ente
in a number "

if you click on the textbox and then check its properties you shoul
seen contoltiptext. enter in the value "please enter in a number " no
when a user moves the mouse over it is will pop up with "please ente
in a number "

hope thats what you mean

Reply to this Message

pschmidt - 20 Mar 2006 18:06 GMT

Yup - that's what I was looking for - thanks!

> i take it you using VBE. if you go on to your userform and then select
> the control you want to change. Say for example you have a normal
[quoted text clipped - 7 lines]
>
> hope thats what you meant

Reply to this Message

K Dales - 20 Mar 2006 17:30 GMT

You can mimic it as long as the area where you want this to appear has a
control that has a MouseMove event.

I created a UserForm with a textbox and a label - the label is what I use
for the "Comment." The following set of routines put in the UserForm's code
module makes the comment appear whenever my mouse is over the textbox:

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)

Me.Label1.Visible = True

End Sub

Private Sub UserForm_Activate()

Me.Label1.Visible = False

End Sub

Private Sub UserForm_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)

Me.Label1.Visible = False

End Sub

Signature

- K Dales

> How can I create a comment like box (like cell comment) on a user form. If a
> user enters an area, this box shows up - no header, etc.
[quoted text clipped - 4 lines]
>
> Perry

Reply to this Message

pschmidt - 20 Mar 2006 18:10 GMT

A good idea - and one i've used before. I didn't want to do this in this
case because I didn't want to take up the 'label room' on the form for
messages - just a little pop-up 'comment' box that I see all the time.

The previous post on controltiptext was exactly what I was looking for.

thanks.

> You can mimic it as long as the area where you want this to appear has a
> control that has a MouseMove event.
[quoted text clipped - 31 lines]
> >
> > Perry

Reply to this Message