如何單擊或雙擊單元格以在Excel中打開指定的用戶表單？

只需單擊或雙擊Excel中的單元格，即可打開指定的用戶窗體。 但是如何實現呢？ 本文中的一種方法可以為您提供幫助。

單擊或雙擊一個單元格以使用VBA代碼打開指定的用戶表單

單擊或雙擊一個單元格以使用VBA代碼打開指定的用戶表單驚人的！ 在 Excel 中使用高效的選項卡，如 Chrome、Firefox 和 Safari！每天節省50％的時間，并減少數千次鼠標單擊！

請執行以下操作以單擊或雙擊單元格以在Excel中打開指定的用戶表單。

1.使用您要單擊的單元格打開工作表，或雙擊以打開用戶表單。

2.右鍵單擊工作表選項卡，然后單擊 查看代碼 從上下文菜單中。 看截圖：

3.在開幕 Microsoft Visual Basic應用程序 窗口，請將以下VBA代碼復制并粘貼到代碼窗口中。

VBA代碼：單擊一個單元格以在Excel中打開指定的用戶表單：

Private Sub Worksheet_SelectionChange(ByVal Target As Range)Updateby20171226If Not Application.Intersect(Target, Range("A1:B9")) Is Nothing ThenUserForm1.ShowEnd IfEnd SubCopyVBA code: Double click a cell to open a specified user form in Excel:Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)Updateby20171226If Not Application.Intersect(Target, Range("A1:B9")) Is Nothing ThenCancel = TrueUserForm1.ShowEnd IfEnd SubNote: In the code, A1:B9 is the cell range you will open user form based on. And UserForm1 is the name of the user form you will open by clicking or double-clicking cells. Please change it based on your need.4. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.From now on, when click or double click any cell in a certain range, the specified user form will be opened immediately as below screenshot shown.Related Articles:How to double click a cell to open a specified worksheet in Excel?How to add check mark in a cell with double clicking in Excel?How to auto add/enter current date/time in a cell with double clicking in Excel?How to double click a cell and add 1 to that cell value in Excel?How to pop up a calendar when clicking a specific cell in Excel?Best Office Productivity ToolsTransform Hours into Minutes with Kutools for Excel!Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!Why You Need Kutools for Excel