G
Guest
I have some simple code, which compares cells in two adjacent columns. If any two cells in one row are not equal, it displays a UserForm. When I call the UserForm, I use a vbModeless command, so that calling this UserForm does not stop the rest of the macro. Example:
UserForm2.Show vbModeless
Since I have a lot of numbers changing, I need to have the userform pop up many times, each time the two cells in any row are not equal. Using the above line of code, can the UserForm be called and appear on the screen multiple times? Thank you.
UserForm2.Show vbModeless
Since I have a lot of numbers changing, I need to have the userform pop up many times, each time the two cells in any row are not equal. Using the above line of code, can the UserForm be called and appear on the screen multiple times? Thank you.