Excel VBA combobox update problem
Posted on 2002-03-14
have a form with a combobox list box that gets updated with the program. It's not...
The named range is updating properly, but the form won't... here's my bits of code:
Worksheets("1stontape").Names.Add Name:="firstlist", RefersToR1C1:="=R1C1:R" & maxrowlist + 1 & "C1"
thats for updating the name range..
the rowsource IS set to firstlist. If I manually check the range, it IS working... but my form usually don't display it.... if I play around w/it enough, I might get lucky, but...