VBA & Macro Problems

Add a Tooltip to an Excel VBA UserForm Text Box

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

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.

Add a Tooltip to an Excel VBA UserForm Text 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.
Before you start

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.

Solution 1Recommended

Set the text box ControlTipText property

Use ControlTipText to show brief guidance when the pointer rests over the text box.

1
Open the UserForm

In Excel, select Developer > Visual Basic. In the Project Explorer, open the UserForm containing the serial-number text box.

2
Select the text box

Click the text box on the UserForm, then open View > Properties Window if the Properties window is not visible.

3
Enter the tooltip

Find ControlTipText in the Properties window and type the serial-number instructions in its value field, without quotation marks.

4
Test the tooltip

Run the UserForm and rest the pointer over the text box to check that the guidance appears.

Set the text box ControlTipText property
Keyboard navigation: ControlTipText is a hover tooltip; tabbing to the text box does not reliably display it. Use a visible label if keyboard users need the same guidance.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLSX and XLS filesWork with spreadsheet data in a familiar interfaceUse a lightweight office suite with a free versionMove common Office documents between applications
microsoft office alternative - wps office

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.