Display a selection while UserForm is in focus
 

Hi there folks.

I am using 2002.

In a user form demo I have been using, one of the really nice features
is that it keeps displaying the selection its subs are working on while
the form is in focus.

I am trying to achieve the same in my own application, and how to do
this seems to be eluding me. The following two examples of code do not
achieve the desired result.

Any suggestions would be really appreciated.

Thanks
Geoff

--------------------------------
Sub CommandButton1_Click()
UserForm3.Show
End Sub
--------------------------------
Sub CommandButton1_Click()
UserForm3.Show
Selection.Hidden = False
End Sub
-------------------------------