Hi All....
I tried to ask this yesterday, but I think I explained myself very badly.
I have a cell - we'll call it A1.
Sometimes a USER will change the value in this cell.
Sometimes a MACRO will change the value in this cell.
I need to allow BOTH to happen and I cannot use 2 different cells as my zillion IF statements have already caused this file to be very large.
When a USER changes the value in this cell, I need a userform to appear that requires the user to read a message and confirm the change they've made.
When a MACRO changes the value in this cell, I do NOT want the user to have to deal with the previously mentioned form.
Currently - I have a macro that says: if A1 changes, show the form.
This is fine.. but it means the user still has to deal with the form when the MACRO has changed A1.
What I would like to do is tell the macro that changes A1 to click 'confirm' on the form that appears.
Can I do this?
I tried to ask this yesterday, but I think I explained myself very badly.
I have a cell - we'll call it A1.
Sometimes a USER will change the value in this cell.
Sometimes a MACRO will change the value in this cell.
I need to allow BOTH to happen and I cannot use 2 different cells as my zillion IF statements have already caused this file to be very large.
When a USER changes the value in this cell, I need a userform to appear that requires the user to read a message and confirm the change they've made.
When a MACRO changes the value in this cell, I do NOT want the user to have to deal with the previously mentioned form.
Currently - I have a macro that says: if A1 changes, show the form.
This is fine.. but it means the user still has to deal with the form when the MACRO has changed A1.
What I would like to do is tell the macro that changes A1 to click 'confirm' on the form that appears.
Can I do this?