LemonBradder
02-25-2014, 09:42 AM
Hi all,Hope everything is going well.I am working in excel 2010 and have googled solutions to parts of my problem but can not get them to work togther. What I want is in a userform the following:
Private Sub RunButton_Click() ' Not to be accessed from view macros
Dim String As String, StringArray1() As String, StringArray2() As String
'Code to make Strings and arrays that works
Call Modules!myModule.mySub(String ,StringArray1,StringArray2)
'Modules are in the same VBAProject as Userform
Unload myUserform
End Sub
I appreciate any help guys, this is the last thing I need to get a new tool working and it has got me stumped! Sorry about the no carriage return I will try again in a few hours on a different computer
Private Sub RunButton_Click() ' Not to be accessed from view macros
Dim String As String, StringArray1() As String, StringArray2() As String
'Code to make Strings and arrays that works
Call Modules!myModule.mySub(String ,StringArray1,StringArray2)
'Modules are in the same VBAProject as Userform
Unload myUserform
End Sub
I appreciate any help guys, this is the last thing I need to get a new tool working and it has got me stumped! Sorry about the no carriage return I will try again in a few hours on a different computer