HOW TO ENABLE MACRO IN EXCEL SHEET HOW TO
HOW TO ENABLE MACRO IN EXCEL SHEET CODE

HOW TO ENABLE MACRO IN EXCEL SHEET CODE

Next, follow these steps to create the code that runs when the workbook opens. In this example, the UserForm is named frmParts.To see the UserForm, click the plus sign at the left of the Forms folder, to open the folder.At the left, in the Project Explorer, find the UserForm workbook.In the UserForm workbook, press Alt + F11, to open the Visual Basic Editor (VBE).The first step is to find the name of the UserForm – we need to use that in the code.

HOW TO ENABLE MACRO IN EXCEL SHEET HOW TO

Here’s how to add the code to open the UserForm automatically. In Excel programming, there are “events”, which are actions on a worksheet, or workbook, or other objects.įor this example, the code will run after the “event” of opening a workbook. Instead of using a worksheet button to open the UserForm, you can use a different kind of macro, to show the UserForm automatically, when the workbook opens. Then, just click that button, and a simple macro runs, to open the UserForm. If you check out those UserForm instruction pages, I show how to add a worksheet button to open the UserForm. And for something even fancier, make dependent combo boxes – after you select from the first one, a list of related items appears in the second combo box: UserForm Dependent ComboBoxes.Or, make a form with drop down lists in combo boxes: UserForm with ComboBoxes.You can start with a simple form: Create a Basic UserForm.If you’re not sure how to set up an Excel UserForm, there are step-by-step instructions on my Contextures site. Since the stored data is hidden away, it’s better protected from someone accidentally changing or deleting the records. When you click the “Add this part” button, the data is copied to the first blank row on a hidden worksheet – PartsData. This screen shot shows a UserForm with combo boxes, where you can select from a list of items. But, with a simple macro, you can show Excel UserForm automatically, when workbook opens. Usually, I add a worksheet button that opens the form. You can add a UserForm to your Excel file, so it’s easy for people to enter data, without going to the table where the historical data is stored.

How to enable macro in excel sheet