View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MikeM[_4_] MikeM[_4_] is offline
external usenet poster
 
Posts: 2
Default Making a Dynamic List in Listbox

Never mind, I found outhow to do it -- I thought the
argument for ListFillRange was a range, but it's a string,
"B1:Bxx"

-----Original Message-----
Is it possible to change the length of a list using
listbox? I have 2 listboxes on a worksheet, the first
containing a (fixed) list of the 50 states (A1:A50). On
choosing a state I copy a list of county names into column
B, to which the second listbox is set, using the
ListFillRange property. Is thre some way to change the
ListFillRange to become the right length when the state
changes?
.