wizards for combi boxes

[fishqqq]

I am use to using the wizards for combi boxes in ACCESS but for some
reason i can't find a wizard for excel that i can use for a combi box.
I am not too familiar with formatting in excel but i am assuming it is
similar to access - is this a safe assumption?

I ultimately have a 2 columns of data on a excel spread sheet - one
for cities and another for matching countries

I want to use a combi box that the user will scroll through - pick a
country and see all the matching cities etc.

Can someone show me where to begin?

much appreciated.
S>

 

[Jim Cone]

There is no wizard in Excel to create dependent dropdowns.
Debra Dalgleish has a tutorial using "Data Validation" to create them here...
http://www.contextures.com/xlDataVal02.html
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(excel sorting add-in)

..
..
..

<[email protected]>
wrote in message

I am use to using the wizards for combi boxes in ACCESS but for some
reason i can't find a wizard for excel that i can use for a combi box.
I am not too familiar with formatting in excel but i am assuming it is
similar to access - is this a safe assumption?

I ultimately have a 2 columns of data on a excel spread sheet - one
for cities and another for matching countries

I want to use a combi box that the user will scroll through - pick a
country and see all the matching cities etc.

Can someone show me where to begin?
much appreciated.
S>

 

[fishqqq]

There is no wizard in Excel to create dependent dropdowns.
Debra Dalgleish has a tutorial using "Data Validation" to create them here...http://www.contextures.com/xlDataVal02.html
--
Jim Cone
Portland, Oregon  USAhttp://www.contextures.com/excel-sort-addin.html
(excel sorting add-in)

.
.
.

<[email protected]>
wrote in message
I am use to using the wizards for combi boxes in ACCESS but for some
reason i can't find a wizard for excel that i can use for a combi box.
I am not too familiar with formatting in excel but i am assuming it is
similar to access - is this a safe assumption?

I ultimately have a 2 columns of data on a excel spread sheet - one
for cities and another for matching countries

I want to use a combi box that the user will scroll through - pick a
country and see all the matching cities etc.

Can someone show me where to begin?
much appreciated.
S>

thanks for the link, is there any other way to do this as i found the
link confusing to follow

 

[Gord Dibben]

Did you download the sample workbook in order to see what's taking place?

Did you watch the Video?

What is confusing? Creating range names or???


Gord Dibben MS Excel MVP