Userform values disappearing when Editor open

Ö

Örjan Skoglösa

I have an userform with some controls. The form is opened with a .show
command triggered by a button in the document. All code besides the
..show command resides in the userform module.

If I open the form, change some values, hide the form and open again,
all changes reappear.

But if I first open the VBA Editor (without doing anything else, just
toggle twice with Alt+F11) and then do the same (open, change, hide,
open), the changes disappear and are substitued by the initial values.

If I close the Editor, the changed values stick again.

What could be the reason for that?

TIA

Örjan Skoglösa
 
Ö

Örjan Skoglösa

But then the changes will disappear regardless of whether the code
window is open or not (as I do not save them anywhere outside the
code).

This is not really important, as it is working well in "normal mode".
I was just curious.

Regards,
Örjan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top