ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dependent lists (https://www.excelbanter.com/excel-programming/385119-dependent-lists.html)

[email protected]

Dependent lists
 
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?


Jim Rech

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

--
Jim
wrote in message
ups.com...
| 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?
|



Dave Peterson

Dependent lists
 
Check Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html#TwoWord

wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com