Form To Database Problem

  • Thread starter Thread starter PRINCE21
  • Start date Start date
P

PRINCE21

Hello, i have created a form for users to fill in. I want to transfe
this data to an excel database. But iam not sure how to create thi
database. Basically i need a submit botton that records all the dat
from the form to a next sheet.

Another problem is i have drop down menus i dont know how to transfe
this data ti text as i click on something in the box a number appear
in the linked cell. How can i change say number one to equal somethin
like sales or number 2 to equal finance etc.

Any suggestions Please Help.:confused: :confused
 
If you've created an entry form on the worksheet, you'd need programming
to move the data to the database. For your dropdown lists, you could use
Data>Validation, which would place the selected text in the cell.

However, instead of creating your own form, you may find it easier to
use John Walkenbach's Enhanced Data Form. It's a free add-in, allows
combo boxes, and has unlimited fields.

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