SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello all,
I am after a VBA that displays a message box to prompt the user to complete another cell dependant on the Data Validation List option, i.e. if 'Cancelled by tenant' is selected from the DVL in column H, then column AC also needs to be completed (by selecting 'Cancelled' from that DVL). I want to be able to do this for several choices from the first DVL (e.g. 'Cancelled by LA', 'Cancelled by RSL', 'Completed', 'Refused'). I want to apply this to the whole of the columns (row range 9:568). Oh, and I already have conditional formatting applied (quite a bit, so I wanted an actual message box!). I do have a DV Input Message, but some people still ignore that too!! ? Hence the pop-up message box!
Not sure it's possible with everything I already have set up in this workbook, but any advice would be greatly received!
Ta muchly, folks!
Sara
I am after a VBA that displays a message box to prompt the user to complete another cell dependant on the Data Validation List option, i.e. if 'Cancelled by tenant' is selected from the DVL in column H, then column AC also needs to be completed (by selecting 'Cancelled' from that DVL). I want to be able to do this for several choices from the first DVL (e.g. 'Cancelled by LA', 'Cancelled by RSL', 'Completed', 'Refused'). I want to apply this to the whole of the columns (row range 9:568). Oh, and I already have conditional formatting applied (quite a bit, so I wanted an actual message box!). I do have a DV Input Message, but some people still ignore that too!! ? Hence the pop-up message box!
Not sure it's possible with everything I already have set up in this workbook, but any advice would be greatly received!
Ta muchly, folks!
Sara