We'll need three things: It's important to note that the sheet is named Animals. You don't have to rename the sheet, but be sure to update the code appropriately if you don't. To view this example in the macro designer, use the following steps: If Updated("Status") Then Run Data Macro Macro Name Comments.Add Comment Parameters prm Related ID = [ID] prm Comment ="--Status Changes to "&[Status] prm User ID =[Changed By User ID] End If If Updated("Resolution") Then Run Data Macro Macro Name Comments. Add Item "Male" End With End Sub The User Form_Initialize() procedure populates the three combo box controls when you run the form. If you need to populate using a similar dropdown procedure, be sure to add the Clear method to avoid duplicates. Without it, the procedure duplicates the list every time the user clicks the dropdown button during the same session. You can send screenshots of your data to help clarify your question. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results? Please mention the app and version that you're using. Don't send files unless requested; initial requests for help that arrive with attached files will be deleted unread.
To easily run the User Form, add the procedure shown in Listing B to open the User Form.
Fortunately, accommodating a Table requires only a few changes to the code.
In this article, I'll show you how to use VBA to copy input values from a User Form to a Table object.
To add the new animal record to Animal Table, click the Save Animal button. When creating a User Form, be sure to add adequate error-handling code; this example contains no error handling. You can add the necessary code to the User Form or you can let users decide when and if to save the file. Learn more about Excel's Table object: I answer readers' questions when I can, but there's no guarantee.
Unload Me End Sub Private Sub User Form_Initialize() 'Populate class control. Enter values for a new animal, as shown in Figure E.