Something strange is happening in a code with userforms. I am developing
some code which uses a few userforms. A second userform is called from a
command button on the first userform. Then while in the middle of processing
code from that second userform, program control is suddenly transferred to a
Listbox_click code of the first Userform without any apparent reason. Anyone
have a clue as to what could be causing that ?
Thanks,
JH

Are you hiding or unloading the first form before loading
and showing the second form?

Try the following

....button clicked...
unload me 'or you could use me.hide
FormNumber2.show

-----Original Message-----
Something strange is happening in a code with userforms.
I am developing
some code which uses a few userforms. A second userform
is called from a
command button on the first userform. Then while in the
middle of processing
code from that second userform, program control is
suddenly transferred to a
Listbox_click code of the first Userform without any
apparent reason. Anyone
have a clue as to what could be causing that ?
Thanks,
JH


.

thanks Bob, i had just also discovered it myself, cheers
JH

"bob" wrote in message
...
Are you hiding or unloading the first form before loading
and showing the second form?

Try the following

...button clicked...
unload me 'or you could use me.hide
FormNumber2.show

-----Original Message-----
Something strange is happening in a code with userforms.
I am developing
some code which uses a few userforms. A second userform
is called from a
command button on the first userform. Then while in the
middle of processing
code from that second userform, program control is
suddenly transferred to a
Listbox_click code of the first Userform without any
apparent reason. Anyone
have a clue as to what could be causing that ?
Thanks,
JH


.