VBA UserForm - "Tooltip"

Question

Hello everyone,

I currently have a UserForm which has a textbox. This textbox needs a specific format of text as it's a serial number. When you click the textbox it comes up with a message box saying format has to be XYZ. I'd like to change this so that it is a "tooltip style" method. The reason behind this is that I'd like the tooltip to appear on MouseOver/Hover or Selected (as users can tab index to it).

Any ideas?

Thanks,

Daniel

Answer 1

If you want the "tooltip" to be permanent visible, you have to use a 'Label' control, and then format the label to look like a tooltip (background color, border, etc.).

You can then place the label next to your textbox, where you want your "Tooltip" to be visible.

Answer 2

Daniel,

re:  textbox tooltip

In the VBE, select (click) the textbox on the userform.

In the Properties window, to the right of the "ControlTip Text" item, fill in your message.

(no quote marks needed)

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 3

You're welcome - glad you made it work :-)

Answer 4

Of course! That makes perfect sense!

Thank you Dan

Answer 5

Hello James,

This works but only when you hover over the textbox. I'd like for it to appear whenever the textbox is active.

Any ideas how I can make that happen?

Thanks,

Daniel