Hello everyone,
I have just recently begun using Excel more frequently as well as VBA and have run into a problem with something I am trying to do. I am creating a form where I have created a cell validation in multiple series of columns. Most were just Yes or No available from the list I used. I then added some VBA code which would prevent saving in the workbook if the answer was left blank, but then I could not save so I added "Required Field" to the validation list and saved the workbook with this field selected.
I have two questions - can I select a cell range such as B7:B12 to not allow saving because I tried to do that but kept getting errors so have range("B7") and range("B8") and range("B9") etc.
Second question - Is there a way to not allow saving if the user has not tried to select the answer, for example if they filled out cells b7:b11, and left B12 as "Required Field" it would let them save because there are no blank spaces; does anyone know how to require that the user select something from that list?
Thank you in advance
I have just recently begun using Excel more frequently as well as VBA and have run into a problem with something I am trying to do. I am creating a form where I have created a cell validation in multiple series of columns. Most were just Yes or No available from the list I used. I then added some VBA code which would prevent saving in the workbook if the answer was left blank, but then I could not save so I added "Required Field" to the validation list and saved the workbook with this field selected.
I have two questions - can I select a cell range such as B7:B12 to not allow saving because I tried to do that but kept getting errors so have range("B7") and range("B8") and range("B9") etc.
Second question - Is there a way to not allow saving if the user has not tried to select the answer, for example if they filled out cells b7:b11, and left B12 as "Required Field" it would let them save because there are no blank spaces; does anyone know how to require that the user select something from that list?
Thank you in advance