Hi everyone,
I'm very new to VBA and may question may seem very simple. But nevertheless i'm kind of stuck with the task.
I have a table where in one of its columns is a drop down list. I want VBA to shade out the whole row of the table when one of the values has been chosed from the list.
I made code to format the row:
what I need now is to develope code, that would run the code above as soon as the value in any cell of the table column F is set to one of the drop down list values.
I know that I must place such procedure in Sheet object of the VBA object model, to get VBA react to the change.
Could you please suggest something.?
Bookmarks