CreganTur
08-29-2008, 07:45 AM
Google is failing me today:igiveup:
Cell G2 has a validation list where the value is the named range 'TypeNames'.
When no selection has been made the cell is, of course, blank (or the cell = ""). What I would like have happen is when a User changes the value of G2 to something other than "", I would like the worksheet to automatically create a validation list in H2 that is also set to the named range 'TypeNames'.
This needs to be a continuing process, so that whenever you use a validation list the very next cell, which was previosuly a general cell, becomes a validation list.
I need this to control User input as they are filling out the worksheet.
Cell G2 has a validation list where the value is the named range 'TypeNames'.
When no selection has been made the cell is, of course, blank (or the cell = ""). What I would like have happen is when a User changes the value of G2 to something other than "", I would like the worksheet to automatically create a validation list in H2 that is also set to the named range 'TypeNames'.
This needs to be a continuing process, so that whenever you use a validation list the very next cell, which was previosuly a general cell, becomes a validation list.
I need this to control User input as they are filling out the worksheet.