Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down boxes and if then statements
How would I make a drop down box depentent on the selected informatio
of another drop down box and return a value to a third cel? IE. state......City....Per diem amount so you would select a city form the state drop down box, which woul list the cities of that state in the city drop down box...afte selecting the city it would return the per diem amount of said city t another cel -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down boxes and if then statements
Hi
as a starting point have a look at http://www.contextures.com/xlDataVal02.html -- Regards Frank Kabel Frankfurt, Germany "Aversin " schrieb im Newsbeitrag ... How would I make a drop down box depentent on the selected information of another drop down box and return a value to a third cel? IE. state......City....Per diem amount so you would select a city form the state drop down box, which would list the cities of that state in the city drop down box...after selecting the city it would return the per diem amount of said city to another cell --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down boxes and if then statements
I have a sample workbook for dependent dropdowns. Mail me direct if you want
a copy. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Aversin " wrote in message ... How would I make a drop down box depentent on the selected information of another drop down box and return a value to a third cel? IE. state......City....Per diem amount so you would select a city form the state drop down box, which would list the cities of that state in the city drop down box...after selecting the city it would return the per diem amount of said city to another cell --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using IF statements with a drop-down list | Excel Discussion (Misc queries) | |||
Drop down boxes/tick boxes | Excel Worksheet Functions | |||
Drop down boxes.. | Excel Discussion (Misc queries) | |||
Drop down boxes | Excel Worksheet Functions | |||
drop down boxes | Excel Discussion (Misc queries) |