Good Morning,
I've been putting together a UserForm that utilizes an array in 2 different subs. I want to build the array in 1 sub and then reference it in another. I'm getting:
Compile Error:
Sub or Function not defined
I believe I declared the array corrected as public in the "Workbook_Open" section.
Private Sub Workbook_Open()
Public jobindex As Integer
Public Max As Integer
Max = 15
Public jobdisplay(1 To Max) As String
Then in my userform I get:
For jobindex = 1 To Max
...
jobdisplay(jobindex) = "Rates for " & job & vbCrLf & outlet(1) & outlet(2) & outlet(3) & outlet(4) & outlet(5) & outlet(6) & outlet(7) & outlet(8) & vbCrLf & notes
Any advice? I'm at a dead end!
John
Bookmarks