Refreshing a listbox
They will.
ranswrt wrote:
I didn't know if they would still get looked at as they got further down the
list.
"Dave Peterson" wrote:
Instead of starting new threads, you should follow up to the original post.
ranswrt wrote:
I have been stumped with a listbox added to a worksheet using the control
toolbox. I have been having problems refreshing the listbox when the data
range is changed. I have been using the following code to refresh it:
Sheets("name").OLEObjects("Listbox1").ListFillRang e = Range("rng").address
I have been getting a blank listbox. I can manually enter the range in the
property window for the listfillrange, but when the range is changed the
listbox isn't updated. Is there a better way to update the listbox?
Thanks
--
Dave Peterson
--
Dave Peterson
|