View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug[_9_] Doug[_9_] is offline
external usenet poster
 
Posts: 20
Default Is it possible to call a UserForm multiple times?

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.