• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Working with spreadsheet while form is still active

A button on my userform opens an excel file. I want to edit this file while the form is still loaded. Is there a way to do this.

Thank you.
0
Aiysha
Asked:
Aiysha
  • 2
1 Solution
 
DhaestCommented:
Can you post your code how you open excel ?
Normally if you open an external program, the current program is still running in background.
0
 
Dave BrettVice President - Business EvaluationCommented:
HI AIysha,

If its an Excel userfom you are talking about, then if you display the form modelessly you can interact with the file with the form still open.

UserForm1.Show vbModeless

Cheers

Dave
0
 
AiyshaAuthor Commented:
Thank you.
0
 
Dave BrettVice President - Business EvaluationCommented:
Thanks for the grade
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now