Access to spreadsheets with VBA User Form up

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a User Form I built in VBA for Excel. When it is active/
displayed, I am unable to display any Excel spreadsheets it has used
(still open).

Is there a way around this? Thanks, Alan
 
Do you mean unable to interact, rather than display, spreadsheets?

The default open mode for UserForm.show is Modal, to allow interaction with
other objects you need to open it Mode Less.

Use something like....

UserForm1.Show (0)
 
Back
Top