How to Find a Record From Its Unique ID & UserForm in MS Excel

Microsoft Excel is a spreadsheet software application developed by Microsoft Corporation that is part of the Office Suite of applications. A UserForm is a feature of Excel that allows users to input data into the spreadsheet. You can create UserForms using Excel's Visual Basic Editor (VBE). Once a user inputs data into the UserForm, it is possible to search for records using the unique ID of the record.

Instructions

1. Click on the UserForm. You want to click any area of the UserForm that does not contain data. A toolbox will open.

2. Select the "Run" option from the toolbox.

3. Type the unique ID you want to search for in the "ID" textbook. Press the "Return" button on your keyboard to go to the individual record you searched for.

References

• Contextures: Create an Excel UserForm
• Excel Tip: Create User Forms in Microsoft Excel
• Microsoft: Chapter 20 Creating Advanced User Forms