NotEmptyRowNumber = Sheets("sheet1").Range("a" & Rows.Count).End(xlUp).Row ' Get the row number of the first not empty row from excel the last row to top.
You can see the code comments for a detailed explanation. The complete source code of the above function is as below, when the user clicks the Regist button, it will input the user name and password into the excel worksheet with the tab name Sheet1.The above function will be invoked when the user clicks the Regist button.Double click the Regist button, then it will open the source code editor window, and add the below function in it.How To Add Source Code When User Click The Buttons On User Form. After you add a related control in the user form, you can set the control’s Name, Caption, and Text properties in the control’s properties list under the VBAProject panel.ģ.You can just click the related components in the ToolBox, then drag it to the form body.In this example, we add 2 label text controls ( User Name, and Password), 1 input text box for username, 1 password input text box for the password, and 2 buttons ( Regist, Reset ).There are some controls on the form window.Open the user form designer, when you click the form, it will show the ToolBox window beside the form.We click the View Object sub-menu to show the UserForm designer window on the right side.Right-click UserForm1, and then you can toggle the form GUI designer and source code editor by clicking the View Code / View Object menu item in the popup menu list.Click UserForm1, it will show the user form designer window on the right side.Then you can see there is a new user form created in the VBA window left side, the form name is UserForm1, and it is located in the VBAProject / Forms folder.
Click the Insert -> UserForm menu item in the Microsoft Visual Basic for Applications window top menu bar to create a user form.If you can not find the Developer tab, please read the article How To Enable Developer Tab And Write VBA Source Code In Excel to learn more.Then it will open the Microsoft Visual Basic for Applications window.Click the Developer tab in the excel ribbon, then click the Visual Basic item in the Code group.How To Create A User Form In Excel Using VBA.
0 kommentar(er)
