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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viewing Excel VBA-generated User Form (modal) in Word 5
Using Multiple Monitors with Excel Spreadsheet with VBA Code 1
Excel/VBA Coding Help 4
VB Error in spreadsheet with no VBA code 2
Displaying data in a VBA User Form 1
Opening an Excel Spreadsheet from Access with VBA 9
Launching from IE 1
Excel VBA in Citrix. 0

Back
Top