![]() ![]() InsertLines x + 1, "Sub CommandButton1_Click()" 'Add an event-hander Sub for your CommandButton Set NewButton = ("forms.CommandButton.1") 'Add a CommandButton and Modify it's Properties Properties("Caption") = "Temporary Form" 'Set Properties for Userform (aka: myUserform) 'Locks Excel Spreadsheet and Speeds Up Form ProcessingĪ = False 'Microsoft Visual Basic for Applications Extensibility 5.3 'To do this, go to Tools -> References and find the add-in 'NOTE: You need to set a reference to the extensibility add-in. 'PURPOSE: Create & Modify a Userform with VBA Code
0 Comments
Leave a Reply. |