listbox

  • Thread starter Thread starter rob
  • Start date Start date
R

rob

I have created a listbox and added items using macro control.

The problem is that the content is not displayed at the end of the macro.
I have to scroll down and up to view the content in the listbox.

The listbox1.refresh command in the macro is not accepted.

Any other clue on how to solve this?
 
Leith, it is not.

I have one list in a worksheet, reflecting the content of column U.
Each time the macro adds a record to U, the macro updates the list range
dynamically.
But, it does not show any content unless I scroll down and up, or right and
then left.

I tried .refresh, .repaint, etc.. all returning an error message that the
object does not allow this operation. of course I can add a scroll down,
scroll up in my macro, but that is not as I want it to happen.
 
Back
Top