Access to spreadsheets with VBA User Form up

[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

 

[Nigel]

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)