Thread: Unload A Form based on a Variable in my Module
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Unload A Form based on a Variable in my Module
Something has to change the value of AllDone at some point in the module. You
have to test the value at each point where the value changes.

if AllDone = 1 then Unload(Userform1)

A variable changing state does not generate an event.

--
HTH...

Jim Thomlinson


" wrote:

How do I unload a hidden Userform when a condition in my module
becomes true?
Say, when AllDone = 1?

I'm new to this, please forgive if this is a dumb question.


Reply With QuoteReply With Quote