Make the UserForm modeless:

UserForm1.Show vbModeless

--

Vasant



"questy" wrote in message
...
in sheet I found that when a userform is open in a sheet I can't edit the
data even when I collapse the userform. Is there anything to do to avoid
this.
Thanks in Advance