wizards for combi boxes

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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>
 
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>
 
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>
Click to expand...

thanks for the link, is there any other way to do this as i found the
link confusing to follow
 
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
 
Back
Top