webmeister
New Member
- Joined
- Sep 13, 2006
- Messages
- 38
Yesterday, I asked about how to change the color of a row, based upon what value was selected in a drop-down cell. Thank you to the wonderful folk who responded and helped tremendously! I was able to create a workbook-wide macro after tweaking the code that was suggested.
Is there a way to tie code only to that drop-down cell? In other words, say I have 5 values in the drop-down, "Accepted", "Declined", "Cancelled" and so on. When I choose one of these values from the drop-down, I want the row's color to change immediately after a value is picked.
I simply don't know how to tie code to a specific cell.
If anyone is willing to offer assistance, I sure would be happy!
Thank you to all who reply.....looking forward to it!!
Is there a way to tie code only to that drop-down cell? In other words, say I have 5 values in the drop-down, "Accepted", "Declined", "Cancelled" and so on. When I choose one of these values from the drop-down, I want the row's color to change immediately after a value is picked.
I simply don't know how to tie code to a specific cell.
If anyone is willing to offer assistance, I sure would be happy!
Thank you to all who reply.....looking forward to it!!