Case Statement-smart form

[msteckbeck]

I'm very new to vba coding. I think I need a case statement to make a "smart form". Basically, I want to make certain columns be mandatory to fill out based on the selection from one cell.

If cell A5 says "Change" (value is based on a data validation list), I want columns B, C, D, E, & I to be mandatory (ie the file cannot be saved until they have been populated). Of course, it could be only 5 rows or upto 7000 rows, depending on the user.

If cell A5 says "New", I want columns B, C, F, & G to be mandatory. Again, the number of rows will depend on the user.

Any help would be greatly appreciated!
--Michele

[pr4t3ek]

well this is more complicated than a simple case statement, but in regards to a case statement, see this link. http://www.ozgrid.com/VBA/select-case.htm