Private Sub Workbook_Open()
UserForm1.Show vbModeless


End Sub

"johnrb7865" wrote:

Hi, I've created a form in VB to add and sort information in Excel. Right now
it doesn't allow any interaction with Excel while using the form. I want to
be able to have the form stay open and be able to work in Excel, does anyone
know how I would do that? Now, if I want to do anything in Excel I have to
close the form first.

Thanks,
John