userform closing after input

  • Thread starter Thread starter Paul Tikken
  • Start date Start date
P

Paul Tikken

Hi,

I've got a userform that contains different lists of values, these values
can be transferred to a worksheet by selecting the value you want and then
pressing a command button to transfer it to the active cell. When I do this
the userform closes automatically.

I would like to have the userform open all the time and not to close after a
input.

Who can help?

Paul
 
Thanks for the quick reply,

I've made the userform modeless so I can select the cells and have the
userform displayed as well. If possible I don't want the userform to close,
hide, unload or do anything. I just would like it to stay where it is, so I
can select a cell in the worksheet, look up a value in the userform, press
the button to put the value into the cell, go to the next cell and do it all
over again.

Any ideas?

Paul
 
Thanks, I've got it. Some malfunction in the worksheet, it works fine in
another one!
 
Back
Top