Opening a Userform without opening Excel

[Philosophaie]

I have a userform. I was wondering if I could make it stand alone or be able to run without opening Excel?

 

[kpark91]

You cannot.
If you want something similar you would need to learn VB.NET but it's a totally different program but rooted from the same language called BASIC.

You could try making an event where when the workbook opens, it hides the excel workbook and loading/showing the userform.

I think the command was

Application.Hide
'and
Application.Show

 

[Leith Ross]

Hello Philosophaie,

No, you can not do either. You can create the illusion of the UserForm being a stand alone by using a few tricks.

You would need to hide all the worksheets, the menu bar and command bars, and modify the UserForm to look like a window with minimize and restore buttons and save the workbook. When this workbook is launched, the UserForm is displayed when the workbook opens but application is not visible making the UserForm appear to be a stand alone application.

 

[Jaafar Tribak]

Another trick to completly avoid seeing the brieve opening of the excel application window when opening the workbook is to make the workbook hidden and to run it from a small VBScript or Batch file.