UserForm coding

I have created a userform for an excel file I have been working on. I need help with two things.

1. How would I code the userform so that it automatically pops up when I open the document?

2. How do I code the userform so that I can still access everything else in the workbook without closing the user form? I have tried this

UserForm1.Show vbModeless

but it hasn’t worked for me yet.

Thanks!

By: Kristin Slovick

Leave a Reply

Your email address will not be published. Required fields are marked *