Creating Form

[mvpdep]

Hi all, I hope there is a simple answer to this question so here it goes.

I have a worksheet called 'Options'

On this sheet I have buttons that open other worksheets. One button is Open Form. When this button is clicked the user is taken to a worksheet called ' Form '

On that page I have three inputs 'Company' 'Name' and 'Response'

Company is a drop down selectable
name is a text entry field and response is a Y or N in a selection box. So two part question:

1. How do I create a form in excel? In other words how do I get the first drop down selectable to list all company names listed on a sheet named 'Companies'. The text box I am familiar with as well as the Y/N selection.

2. How do I take the answers the user input on that form and transfer them to a sheet called 'Data' matching existing data already on the form.

The Sheet called Data already has fields:
Biz Name
Address
Name
Phone
Response

So I want to take the user input from the form and put the answers into 'Data' sheet with existing data.

Can this be done?

 

[KenWright]

1) By using Data / Validation, choosing LIST as the source. If the list of names is on another sheet though, you need to name that list and then put the name into the 'refers to' box when you choose List.

2) Either get ready to delve into VBA, or perhaps far more simply, take a look at John Walkenbach's free 'Enhanced Data Form', which is a greatly improved version of Excel's Data / Form, and allows you to use drop down combo boxes.

Now, this may mean a slight alteration to the layout of your file because you may need to work directly on the Data sheet, but you would need to take a look and perhaps try it:-

http://j-walk.com/ss/dataform/index.htm

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------