Excel Online - Prompt User to confirm anytime cell in column is changed?

**Norcal1** · 03-25-2020, 01:26 PM

Trying to put together a makeshift approval log for outgoing correspondence on some short notice. I cannot seem to figure a way to do this without VBA (there might now be) which won't work as we want the file online so that 1 or more of our 3 Project Managers can access at the same time.

We have 3 PMs, each who need to give approval to a document in the log. They each have a column with a validated dropdown list to select either "Approve" or "Revise". What I would like, if possible, is to have a prompt, no matter what, asking the user to confirm the change in the dropdown list. So if a PM goes in and says "Approve" to item 5, it prompts and says "Are you sure you want to change Item 5 to approved".

I could make this happen with VBA, but falling short without it. I think I can make it happen with validation if they put in the wrong cell value, but I need the prompt for any cell value including the correct values.

**Paul** · 03-25-2020, 01:48 PM

Data validation rules will only pop up a warning if you enter an incorrect value in the validated cell. If they're picking a valid value from a validation list, it will never be incorrect and thus won't pop up a warning or prevent them from selecting a value. The only way to do this would be VBA, to my knowledge.

In VBA, you would just use the Worksheet_Change event and check to see if your range of validated cells has changed, for example:

Please Login or Register  to view this content.

**Norcal1** · 03-25-2020, 01:50 PM

This is what i figured, although your code is much more succinct than mine would have been. Appreciate the input, sounds like no way to do with Excel online at this time (wonder if MS will be adding VBA support to excel online in the future, would be huge). May have to look into using google sheets for this since it could be self contained.

thanks again

**ChemistB** · 03-25-2020, 02:42 PM

A possible workaround. How important is the dropdown menu? After the first entry of both "Approve" and "Revise," Excel will autofill anyway. See if attached solution is acceptable (Col D). I set the Validation to "Warning" instead of "Stop." and the criteria to neither "Approve" or "Revise."