I think it's almost impossible to embed it to the worksheet.
for many years, i've tried but failed.

if you can make the userform show only on a specific worjsheet,
you would have better use event procedure.

for example,
Private Sub Worksheet_Activate()
userform1.Show vbModeless
End Sub

Private Sub Worksheet_Deactivate()
userform1.Hide
End Sub

--
msn
---------------------------------------------
the best time to plant a tree was twenty years ago.
the second best time, is today - Chinese proverb



" wrote:

On Apr 17, 9:51 pm, wrote:
Hi I recently posted a question about a user form and got it working
and figured out how to get it into excel...however, the only problem
is it only runs as soon as excel starts up and then waits for the user
to exit out of the box. Also, while it is up, it restricts the spread
sheet from being edited. Is there a way I could have the box always
be there and be able to simultaneously edit the spreadsheet? Sorry if
it is a bit unclear.

thank you!

Thank you for your response! I have one more question...is there a
way I could either make the box stay on just one worksheet (say one
called rev and exp) rather than having it stay open while looking at
other worksheets? Or could I directly embed it into a worksheet?