I have been looking for a solution to this problem for a long time. I
still don't have it. But I don't agree with the previous reply.

You CAN have a userform visible while you work in the worksheet.
I have a permanent userform visible simply by a macro like
Worksheet.activate ... Userform.Show.
I enter codes from a listbox in the userform to cells in the worksheet.
Subsequently, I click on the worksheet to set the focus on the
worksheet and then I can work in the sheet. Meanwhile the userform is
still visible!
As this is possible, I am looking for a programming code that
automatically brings back the focus to the worksheet (after I have
chosen from the listbox in the userform).

Userform.Hide is therefor not appropriate.
Worksheet.activate does not do what we want.

We'll wait for suggestions...


---
Message posted from http://www.ExcelForum.com/