Forum Discussion
Excel Forms Dropdown list
Hello Team. Is it possible to create a dropdown list in the excel form box? I want to use the form to enter data into a table but I'd like to have drop down lists for a few of the input fields, eg ...
Unfortunately, the built-in Data Form is not customizable. You'll have to design your own form as a userform in the Visual Basic Editor.
How do I that?
Note that am new to excel.This is not a task for a beginner, so you'll have to become proficient in Excel and VBA first.
Excel Easy has a series of free tutorials, both for Excel and VBA.
Thank you for your help, I will surely check it out.
