Dependent lists

B

buattis

Hi,

I have three levels of dependent lists.

I have restricted data entry using validation lists.

User can select Country from the first list.

This then dictates what they can select from State

This then dictates what they can select from Region

The problem is that I can only define the named lists with one word
and its not very pleasing to the eye when the user sees

South_east_precinct

how can i allow the defined lists to have spaces and special
characters?
 
J

Jim Rech

No spaces in name and no way around it. If you don't like
South_east_precinct how about SouthEastPrecinct?

--
Jim
| Hi,
|
| I have three levels of dependent lists.
|
| I have restricted data entry using validation lists.
|
| User can select Country from the first list.
|
| This then dictates what they can select from State
|
| This then dictates what they can select from Region
|
| The problem is that I can only define the named lists with one word
| and its not very pleasing to the eye when the user sees
|
| South_east_precinct
|
| how can i allow the defined lists to have spaces and special
| characters?
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to: Create Dependent Drop Down in a Form 2
need VBA to clear dependent data validation lists in several rows 4
Validation Lists 4
Cell Changes with Dependent Validation 3
data validation from multiple lists 8
multiple dependent drop down lists 6
stumped on creating dependent data validation lists 1
Creating Dependent lists 1

Top