Excel VBA user form

Question

I created a userform that I would like to keep open on my desk top. Problem is I cannot open an existing excel spread sheet. I have to close my userform first or open the program excel and then open my worksheet. I cannot go to "my documents" and open an existing excel worksheet directly. Any idea's would be greatly appreciated. I am not the only person using the VBA userform.

basodre · Accepted Answer · 2015-02-27 14:38:46Z

2

Try setting the Userform's ShowModal property to False

answered Feb 27, 2015 at 14:38

basodre

5,7901 gold badge18 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA user form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related