VBA code for multiple ranges

[Novice18]

Hi There,

My knowledge of VBA is limited and I have encountered a problem i was hoping someone could help me with.

I want to create a code where if text is entered in cell A13, Cells B13:Z13 are mandatory before saving. This needs to be repeated so that when text is entered in cell A14, cells B14:Z14 are mandatory and so on for about 40 rows. As long as column A is blank from A13 upwards no fields are mandatory.

Also I want to have a mandatory cell that contains a date which has to either be the current date or a date in the future. I don't want the user to be able to save the document unless the date has been entered correctly. Ideally this cell would be blank every-time a new version of the document is created.

Please help!

Thanks

 

[James006]

Hi,

It seems you are after a solution to force input ... :wink:

You can take advantage of following solution : Requiring Input (Microsoft Excel)

HTH