sheetChange event and list validation

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

Guest

in Worksheet_Change sub-routine, i have certain cells change the interior
pattern whenever the column of the cell is let say 5. the cells in column 5
are list validation. when i change the value through the list it goes into
the code and goes thru the code correctly but the interior pattern did not
change. I am currently using windows XP Pro and office XP Pro. Thank you!

Nick
 
Hi Nick,

Please supply your code so that people may give you the correc
response or solve your problem.

Simo
 
You must log in or register to reply here.

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

Sheet change event and list validation question 1
SheetChange Event 2
Cause of SheetChange Event 6
Replacing a hardcoded date 3
Excel hangs 1
Data Validation List (conditional) 2
get values and colors back in a cell 1
Find Cell When Interior.ColorIndex =3 1

Back
Top