Userform not initializing properly...

[michaeljoeyeager]

Hello. I am new to this forum so please forgive any breaks in protocol.

I have a Macro that creates a new sheet and fills in certain cells based on a userform. Everytime the Macro runs it initializes the fields based on what was entered on the active worksheet.

The strange part is this: It works perfectly once. But when you run it again the userform fields still initialize but to incorrect values. Stranger still, if you close out of the userform and then immedietey run te macro again i works perfectly.

I have global variables that keep track of what these userform fields should initialize to...

Please Login or Register  to view this content.

Then running the Macro...

Please Login or Register  to view this content.

Then the user form execution...

Please Login or Register  to view this content.

I am new to this so please excuse the rudimentary programming... but any help woul be greatly appreciated!

Thanks in advance,

Mike

[michaeljoeyeager]

Well I solved my own problem...

Turns out I was only hiding the userform and not unloading it...