Accessing

[PATRON58]

Hello all,

Am quite new to VBA although have briefly (very) used VB.Net.

Have created a series of forms using formula within Excel and am now just about finished. This may seem a simple question but I really don't know what I do next. How do I go about transforming these connected forms into a stand-alone application? I know there was an install wizard in VB.Net but have no idea how to go about making this an installable application with VBA.


Any siggestions would be very much appreciated!

PAtron

 

[SkipVought]

PAtron,

VBA runs within the application.

You can run any procedure using a number of techinques...

Tools/Macro/Macros - select one and RUN

Associate a Procedure with an Event - like button_click, Worksheet_Change or Worksheet_SelectionChange.

VBA can be compiled in the VB Editor, but it does not create an executable. You just RUN the code that's there.

By "form" do you mean a UserForm control or a Worksheet on which you have designed a "form"???

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[PATRON58]

Hi Skip,

Thanks for the quick reply. They are a series of Userforms through which the user inputs data which is then calculated in the worksheet and the calculations displayed back through the objects.

Any idea how I could go about getting it to create an executable?

 

[SkipVought]

As I stated before, there is NO executable.

Usually from a Userform, you run various code using control events.

Show the form, for instance, in the Workbook_Open event.

Explain in more detail, how your application should work.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[PATRON58]

It is a series of userforms which start off at a login before going onto some others for performing loads of calculations.

Currently to get to the first sreen the user needs to open excel, open the file, to the editor, find the login screen and then press the run button. A bit long in the tooth at the moment.

I would like to get the first form to be openable straight from an icon on the desktop but have no idea as to how to go about this.

Patron

 

[SkipVought]

On the desktop, a shortcut to your workbook.

In the Workbook_Open event

Private Sub Workbook_Open()
   LogonForm.Show
End Sub

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[PATRON58]

Golly, its as simple as that? Yikes. Thought it would be far more around the houses. Thank you very much skip, will give it a try.

Thank you!

Patron

 

[SkipVought]

Be aware that the Workbook_Open event is in the ThisWorkbook Object, Code Window.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[PATRON58]

Yep, that did the trick brilliantly!

Thank you very much,


Patron

 

[WalkerEvans]

Skip,

According to my spouse, it's a good idea to punch-out a contented seance leader whenever possible. As she likes to put it:

"Always try to stike a happy medium!"

----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long

 

[SkipVought]

I always thot that it was apply a switch to a witch, which was waxing wacky-cackle.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[WalkerEvans]

Skip,

I surrender!!


----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long