Add a Tooltip to an Excel VBA UserForm Text Box
Question details
The user wants to provide serial-number format guidance for a text box on an Excel VBA UserForm without displaying a message box.

- Product
- Microsoft Excel VBA
- Device & OS
- not provided
- Scenario
- Users enter a serial number in a UserForm text box and need guidance when hovering over or tabbing to it.
- Observed behavior
- The desired guidance should appear on hover or remain visible while users navigate the form by keyboard.
Open the workbook containing the UserForm and confirm the serial-number format you want to describe. Make sure you can access the Visual Basic Editor and the form's text box.
Set the text box ControlTipText property
Use ControlTipText to show brief guidance when the pointer rests over the text box.
In Excel, select Developer > Visual Basic. In the Project Explorer, open the UserForm containing the serial-number text box.
Click the text box on the UserForm, then open View > Properties Window if the Properties window is not visible.
Find ControlTipText in the Properties window and type the serial-number instructions in its value field, without quotation marks.
Run the UserForm and rest the pointer over the text box to check that the guidance appears.

Add a visible label beside the text box
Use a label when instructions need to remain visible while users tab through the form.
Work with Excel files in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets and moving between common Office formats. Use Microsoft Excel to edit and test this VBA UserForm; WPS macro support may vary by version and platform.

Frequently Asked Questions
Where is the ControlTipText property?
In the Visual Basic Editor, select the text box on the UserForm and open View > Properties Window. Find ControlTipText in the property list.
Should I put quotation marks around the tooltip text?
No. When entering the message directly in the ControlTipText property field, type the guidance without quotation marks.
Will the tooltip appear when I tab to the text box?
ControlTipText is intended for pointer hover and does not reliably appear on keyboard focus. Add a Label beside the text box to keep the instructions visible during tab navigation.
Does ControlTipText validate the serial number?
No. It only displays guidance. If the format must be enforced, add separate validation code to the UserForm.




