I need to create a custom form in excel

[Guest]

I am have created a speadsheet to capture client information including sales
info (one client per row). To keep this simple for my users I want to create
a form that will capture each cell and populate the sheet like a list.
Clicking data then form doesn't work. Please help. I'm good at excel but have
no idea in VBA so if this is the answer please talk to me like i'm stupid!

Thanks

 

[Mark]

Hi,
Send me the worksheet so I can see the layout structure.

See my stuff at:
http://www.geocities.com/excelmarksway

- Mark
(e-mail address removed)

 

[Dave Peterson]

Look at Data|form. Maybe you don't need any VBA at all.

If you like it, but it's too limited, you can try John Walkenbach's enhanced
dataform:
http://j-walk.com/ss/dataform/index.htm

And if you want to learn a bit about userforms, visit Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html

 

[Chris Ferguson]

Hi

Assuming you have a unique identifyer for each customer. Make sure that
identifyer is in the lefthand most column.
Then you can design another sheet and use multiple vlookups to populate this
other sheet based upon one cell. You could also validate the data in this
one cell so that you can select the customers from the list of unique
identifyers.

I have used this technique for a smiple purchase order recording system
where the identiyer is the purchase order number and the form is designed to
look like a printed purchase order.

Regards

Chris