It looks ok to me. What part of it breaks?
peter_rivera wrote:
I figured what my problem was. I was declaring a public variable in the
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_rivera
------------------------------------------------------------------------
peter_rivera's Profile: http://www.excelforum.com/member.php...o&userid=24495
View this thread: http://www.excelforum.com/showthread...hreadid=381591
--
Dave Peterson