VBA: When conditions are met, a message box will pop up

JennV

New Member
Joined
May 9, 2019
Messages
32
Sheet1:
1Cat2019-05-21Error... This, this, and this
2Dog2019-05-21Error. This, this, and this
3Mouse2019-05-25In order - that, that, and that
4Fish2019-05-26Where, when, why, and how

<tbody>
</tbody>

Sheet2:
52019-05-22Dog...
62019-05-22Fish...
72019-05-22Mouse

<tbody>
</tbody>

Sheet1 is my database while Sheet2 is where the user inputs data. Since there is Mouse and in the comments, it mentions 'In order', is there a way to generate a message pop up when the user tries to input comments for Mouse on Sheet2: "Note: Mouse has been previously input with 'In order'." but still allows the user to continue inputting their comments after closing that pop up? On the contrary, if Mouse had been previously input and the comments didn't mention 'In order', the pop up won't show up.

I know how to generate a userform in VBA but I'm still a beginner. I'm not sure if what I'm trying to do is possible...

Any help or guidance will be much appreciate, thank you in advance!
 

Forum statistics

Threads
1,078,218
Messages
5,338,913
Members
399,267
Latest member
Danielle1017

Some videos you may like

This Week's Hot Topics

Top