I am trying to create a form which has drop down boxes with choices and then
those choices fill in a form on another page - can anyone lead me in the
right direction to create this form?

do you mean a userform?

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default...b;en-us;829070



http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

http://www.bmsltd.ie/Excel/Default.htm
http://maths.sci.shu.ac.uk/units/ioa/ <- Excel VBA tutorial


--
Regards,
Tom Ogilvy


"Sierra Coating" wrote in message
...
I am trying to create a form which has drop down boxes with choices and
then
those choices fill in a form on another page - can anyone lead me in the
right direction to create this form?

Or, if you want the dropdown lists on the worksheet, you can use data
validation. There's information in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

To show the selections on another sheet, you can link the cells --

On the second sheet, select the cell where you want to see information
from the first sheet
Type an equal sign
Select the first sheet, and click on the cell you want to link
Press the Enter key

Sierra Coating wrote:
I am trying to create a form which has drop down boxes with choices and then
those choices fill in a form on another page - can anyone lead me in the
right direction to create this form?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html