listbox

[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?

 

[rob]

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.