M
mikey may
I have a macro that uses an input form to populate a
spreadsheet. There are various validations that run prior
to the data populating. On one validation if an incorrect
choice has been made from a drop down box a error message
prompts the user to select again form the drop down box
and will not populate until a valid selection has been
made.
I am now getting an Excel warning message (exclamation
message) saying 'Invalid Property Value' after the
spreadsheet has populated which only happens if an invalid
selection has been made and corrected from the drop down
box. If the initial selections that have been made are
valid then the message does not appear!!! It doesn't seem
to be doing any harm but is rather annoying.
I have checked my code, which obviousley works or the data
wouldn't populate, so any ideas????
spreadsheet. There are various validations that run prior
to the data populating. On one validation if an incorrect
choice has been made from a drop down box a error message
prompts the user to select again form the drop down box
and will not populate until a valid selection has been
made.
I am now getting an Excel warning message (exclamation
message) saying 'Invalid Property Value' after the
spreadsheet has populated which only happens if an invalid
selection has been made and corrected from the drop down
box. If the initial selections that have been made are
valid then the message does not appear!!! It doesn't seem
to be doing any harm but is rather annoying.
I have checked my code, which obviousley works or the data
wouldn't populate, so any ideas????