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

Make it modal and hide it instead of unloading it.

"Paul Tikken" wrote:

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

"JLGWhiz" wrote:

Make it modal and hide it instead of unloading it.

"Paul Tikken" wrote:

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, I've got it. Some malfunction in the worksheet, it works fine in
another one!

"JLGWhiz" wrote:

Make it modal and hide it instead of unloading it.

"Paul Tikken" wrote:

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