UserForm
How do i put the cursor in TextBox in Userform automatically when form
is called by userform1.show. I want this for entering a password for opening an excel file. Please Tell Me Mahesh Baldi India |
UserForm
Try code like the following in the form's code module.
Private Sub UserForm_Activate() Me.TextBox2.SetFocus End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mahesh Baldi - India" wrote in message oups.com... How do i put the cursor in TextBox in Userform automatically when form is called by userform1.show. I want this for entering a password for opening an excel file. Please Tell Me Mahesh Baldi India |
UserForm
there should be a option called Tab Index in the properties window.
Select the textbox you want as your password and set the TabIndex to 0. You can go through the rest of your items and index them in order. When someone hits tab it will go from 0--1--2 etc. When you add a new item you will have to index it correctly. Let me know if this helps. -Justin |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com