I figured what my problem was. I was declaring a public variable in th
wrong place. I have another problem though as the code:
Private Sub Listbox1_Change()
With Worksheets(g_Country)
.ListBox1.ListFillRange = ""
.ListBox1.List = .Range("a1", .Cells(.Rows.Count
"A").End(xlUp)).Value
End With
does not work. Any thoughts? Thanks
--
peter_river
-----------------------------------------------------------------------
peter_rivera's Profile:
http://www.excelforum.com/member.php...fo&userid=2449
View this thread:
http://www.excelforum.com/showthread.php?threadid=38159