Launch from Macros View Macros

[bklabel1]

I can run my code by clicking on the green arrow.

How do I get it to run from the tool bar when the spreadsheet is displayed?

I want to go to Macros -> View Macros , highlight a macro and then press run the run button.

My app only has one user form with a button.

I would like to start from the top Sub that says Sheet__To _Param_Data(). I don't know what this function should call or what object it should be attached to get it running.

My subs look like this:

Sub Sheet_To_Param_Data()
'
' Sheet_To_Param_Data Macro
'



End Sub

Private Sub CommandButton1_Click()
Call CommandButton3_Click
End Sub



Private Sub CommandButton3_Click()
Dim row As Integer, col As Integer
Dim rowContents As Integer, colContents As Integer
Dim length As Integer
Dim field As Variant
Dim OutputText As Variant

Thank you very much,

Kevin

 

[NateSC]

Do you have all of the macros inside the UserForm? If so, then you need a macro either in a Sheet or a Module that you can run from the Macro - Run button. For example, you can go into the VBA editor, select "ThisWorkbook" in the Project window, and then add a new sub (i.e. Sub myStart())
Inside your initial Sub, you might do some stuff and then you would Load your UserForm and then Show your UserForm.

Sub myStart()
'Do some stuff here
Load UserForm1
'You can do more stuff here to modify the form if needed before making it visible
UserForm1.Show
End Sub

I'm not sure how your Sub Sheet_To_Param_Data() interfaces with the UserForm. The way they interact will determine how you Call/launch that Sub.