Excel Forms Dropdown list

Question

Hello Team.&nbsp;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 Handled by.&nbsp;&nbsp;Note I have&nbsp;Find attached the form, please&nbsp;&nbsp;

hansvogelaar · Answer

Musanda&nbsp;
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.

musanda · Answer

HansVogelaar&nbsp;How do I that?&nbsp;Note that am new to excel.&nbsp;

hansvogelaar · Answer

Musanda&nbsp;
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.

musanda · Answer

Thank you for your help, I will surely check it out.

Forum Discussion

Excel Forms Dropdown list

4 Replies

Resources