Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Functions
I have an excel Sheet in 2003. I am making a Configurator for like Computer
Systems. I am using drop down menu's for selecting of options. I have the options actually in a separate sheet, and i have the drop down list linked to the Data sheet. What I would love to do though is actually make the form to where when ever they select an option from that Drop down list, it takes the cost of that item from the Data sheet, and adds it to the total. So by the time they are done configuring the system, they would have their total cost on the system. Is there a way you can help me with this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Functions
Hi Eric,
One way of doing this is by using the 'drop down' (combo) boxes in the control toolbar (not on the forms toolbar) The range of your data sheet go in 'ListFillRange' and the cell you want the valut to be written to is 'LinkedCell'. Set the 'BoundCollumn' to the colum of your range the values sit in and change 'ColumnCount' the the number of colums you want to display. HTH Simon Eric Svatik wrote: I have an excel Sheet in 2003. I am making a Configurator for like Computer Systems. I am using drop down menu's for selecting of options. I have the options actually in a separate sheet, and i have the drop down list linked to the Data sheet. What I would love to do though is actually make the form to where when ever they select an option from that Drop down list, it takes the cost of that item from the Data sheet, and adds it to the total. So by the time they are done configuring the system, they would have their total cost on the system. Is there a way you can help me with this. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200704/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) |