Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have data validation on 15 cells only. These 15 cells are for
account numbers. I have a list of valid account numbers on a hidden
worksheet.

I've seen some comments on adding validation to a whole column. Can I
progam the workbook, so the validation only applies to 15 cells on a specific
sheet?

Any suggestions or code to get me started would be appreciated. As always,
Thanks for all of the help in this newsgroup.....
 
turn on the macro recorder

Select the 15 cells,
Manually apply the data=>Validation.
turn off the macro recorder.

Examine the code
(assumes you have a defined name that refers to the range of acceptable
entries on the other sheet - which is a requirement to use data validation. )

there is no reason to apply data validation to the whole column if you only
want to do it to 15 cells.
 

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

execute assigned data validation in vba? 11
Hide column based on data validation 0
Data Validation List (conditional) 2
best way to validate data in forms; 2010 1
If formula and Data Validation parallely 1
Excel VBA Replace Data Validation Titles and Input Messages 2
Data Validation -> Validation list is larger than the cell width 1
data lookup/validation syntax 2

Back
Top