Creating forms in excel

[Guest]

I would like to create an excel spreadsheet that I would use to track
documents. I would like to use checkboxes to indicate whether certain
documents have been received in house. My question is do I have to link the
checkbox to a cell? Also, if you have combo boxes, options groups etc. on a
form are the answers linked to cells in another spreadsheet with the columns
named the same as the labels on the form. Is there a website I could go to
learn more about using forms in excel. I am using Excel 2003.

Thanks very much for your help.

Best regards,

Dee

 

[Damon Longworth]

Here are a few places to learn:

http://maths.sci.shu.ac.uk/units/ioa/notes/userforms.shtml

http://support.microsoft.com/kb/q168067/

http://fontstuff.com/downloads/ ' VBA04-UserForms.xls

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com