VBA coding

[kittybaker007]

Private Sub UserForm_Initialize()
Dim i As Integer

For i = 1 To NProducts
ProductListBox.AddItem Product(i)
Next
ProductListBox.Selected(0) = True
End Sub

this is my code for one of my forms....it is telling me that Product(i) is not defined even though i have defined it in Module 1 Product() As String. What am I doing wrong

 

[DRJ]

You have to declare it as public if you want anything outside the sub to know what you are talking about.

Like this

Dim x as integer
sub test()
codehere
end sub

This way other subs and userforms will know what x is.

If you do it like

sub test()
dim x as integer
code here
end sub

only sub test will know what x is and nothing else.

Hopefully this makes sense

Jacob