dancingbear
07-23-2008, 01:21 PM
First off, I must say that I'm a complete newb to vba.
I'm using Excel 2003.
I am trying to accomplish the following...
I have a spreadsheet that is used as a form to gather data (not an actual Form, just data in cells). Row 1 has "headers": Name, Purchasing country, end user, lamp system, etc. Starting in Row 2, the users will type in the data.
I want to make some fields mandatory. The number of rows will vary. If the user enters data in column A, they must be forced to complete columns E - O also. I've been googling all day trying to make this work, but have had no luck.
:banghead:
Any insight or help would be very appreciated!!!
I'm using Excel 2003.
I am trying to accomplish the following...
I have a spreadsheet that is used as a form to gather data (not an actual Form, just data in cells). Row 1 has "headers": Name, Purchasing country, end user, lamp system, etc. Starting in Row 2, the users will type in the data.
I want to make some fields mandatory. The number of rows will vary. If the user enters data in column A, they must be forced to complete columns E - O also. I've been googling all day trying to make this work, but have had no luck.
:banghead:
Any insight or help would be very appreciated!!!