View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Is it possible to call a UserForm multiple times?

Doug,

No you won't be able to. You can issue the command multiple times, but as it
is already in memory, it will reuse that same userform.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Doug" wrote in message
...
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.