Excel Form 1

[hp7166]

Hey Guys and Girls i know this may sound a stupid question but i looking for create a form in excel. I want to be able to create a drop down box with a few text items in. So it makes it easier to input the correct reason into a spreadsheet

Hope you can help

Rob

 

[dcurtis]

Open your spreadsheet -> Alt+F11 (opens the VBA editor) -> Insert -> User Form.

If you need help with the specifics on the form, repost here.

 

[BlueHorizon]

Hi hp7166,
You can add a drop down list to a cell or column in this way: Somewhere on your worksheet, enter the list of entries you want to use. Then highlight the column or cell that you want the drop list to appear in. Go to Data | Validation. In Allow:, select List. Click in Source and highlight the cell range on worksheet with your list entries. Click OK. A drop down arrow appears in the cell and your list is visible when you click on it.
Good luck,
BlueHorizon