I designed my VBA project wrong from the beginning, how do I get out of the corner now.

[1953emp]

I am using Excel 2010 VBA7.0


I started from a workbook developer tab, selecting the Visual Basic tab, I inserted a form for a GUI and proceeded to populate it with various widgets, all the underlying code in the same form. It is huge and unwieldy but works great. The only way I can start it is to open the workbook, click on developer, click on Visual Basic and click the little green RUN arrow. I wanted to be able to start this from a START button on the workbook, but I am now painted into a corner. I've tried to separate the parts by starting a new project, breaking things out into modules with no success.


Is there a way for me to get to where I want to be, running this from a START button instead of going through all the clicks.


Thanks all


emp53

 

[Fluff]

Are you talking about a userform, or just controls on a sheet?

 

[1953emp]

Are you talking about a userform, or just controls on a sheet?

A user form.

 

[1953emp]

Are you talking about a userform, or just controls on a sheet?

Two things I forgot to state: I am developing on Win7, deploying on Win10. The Win10 deployment works, The people using this are not too computer saavy and I don't want the mucking around in the guts of this app.
Thanks for the response

 

[Fluff]

Regardless of OS you should be able to put a button/shape on the sheet & assign a macro to it, that shows the form.

 

[1953emp]

Here's the project layout, There is no named macro, I just started designing.

 

[Fluff]

You can simply assign a macro like this

Sub Launch()
   UserForm1.Show
End Sub

To a shape or Form control button on a sheet, which will then show the userform

 

[1953emp]

You can simply assign a macro like this

Sub Launch()
   UserForm1.Show
End Sub

To a shape or Form control button on a sheet, which will then show the userform

I implemented it as you recommended and all is working as I desire it to. Thanks for all your help. How do I mark this as solved?

 

[Fluff]

You're welcome & thanks for the feedback.

We don't mark threads as solved here