ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating forms in excel (https://www.excelbanter.com/excel-discussion-misc-queries/37450-creating-forms-excel.html)

Dee

Creating forms in excel
 
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...serforms.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


"Dee" wrote in message
...
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





All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com