VBA & Macro Problems

Fix Excel Text Box Requiring Two Clicks in Multipage UserForm

Maira Mehtab Sep 20, 2026 869 views

Question details

The user is experiencing an issue where a text box within a multipage control requires two clicks to become active and editable.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using an interactive multipage control containing a text box directly on a spreadsheet.
Observed behavior: The text box fails to gain focus on the first click and requires a second click before the user can begin typing.

Before you start

Ensure the Developer tab is enabled in your Excel ribbon and save a backup copy of your workbook before modifying VBA code or moving ActiveX controls.

Solution 1Recommended

Move the Multipage Control to a VBA UserForm

Since multipage controls are inherently designed for UserForms, moving them off the worksheet prevents focus conflicts.

Placing a multipage control directly onto an Excel worksheet often causes focus and event-handling glitches, such as the text box requiring two clicks. The most reliable fix is to host the multipage control inside a standard VBA UserForm where focus behaves natively.

Open the VBA Editor

Press Alt + F11 in Excel to launch the Visual Basic for Applications (VBA) Editor.

Insert a New UserForm

Click on 'Insert' in the top menu and select 'UserForm' to create a new blank form.

Add the Multipage Control

From the Toolbox window, select the 'MultiPage' control and draw it onto your new UserForm.

Transfer Your Text Boxes

Add your Text Box controls directly into the pages of this UserForm instead of the worksheet.

Trigger the UserForm

Add a standard Form Button to your worksheet and assign a simple macro containing `UserForm1.Show` to display the form with a single click.

Best Practice: Using UserForms for complex controls ensures maximum compatibility and prevents interface bugs across different versions of Excel.

Solution 2

Force Focus Using VBA Event Handling

Use VBA event macros to manually force the text box to activate upon the first interaction if you must keep the control on the worksheet.

Free Microsoft Office alternative

Upgrade to WPS Office for a Seamless Spreadsheet Experience

If you are frustrated by ActiveX control glitches and focus issues on Microsoft Excel worksheets, consider switching to WPS Office. It provides a highly compatible, lightweight, and modern alternative for all your spreadsheet and data management needs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheets and open your existing Excel workbook directly without any format conversion.
3. Enjoy Glitch-Free Editing: Experience smooth data entry and interface interactions within a highly optimized environment.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight architecture ensures fast installation and quick file launch timesFree to use with an intuitive interface that requires no learning curveRobust support for complex data analysis without the legacy bugs of older spreadsheet software

microsoft office alternative - wps office

Frequently Asked Questions

Why do ActiveX controls behave strangely directly on Excel worksheets?

Excel worksheets are optimized primarily for calculating cells and ranges. Complex ActiveX controls like the Multipage tool are designed to be hosted in VBA UserForms, so placing them directly on the spreadsheet grid often leads to focus, scaling, and event-triggering bugs.

Can I fix the two-click issue without moving the control to a UserForm?

You can try VBA workarounds, such as forcing focus via the MouseDown or Click events of the control using `TextBox1.Activate`. However, these methods are often unreliable and may not work identically across all computers.

What is the best practice for using a Multipage control?

The standard best practice is to always place a Multipage control inside a VBA UserForm. You can access the UserForm designer by pressing Alt + F11, inserting a new UserForm, and adding your controls there for a bug-free experience.

Excel & Data Problems