ClimoC
Well-known Member
- Joined
- Aug 21, 2009
- Messages
- 584
I have a worksheet listbox. When the user clicks a command button, it executes a macro using the value of the listbox's linked cell.
It goes to another sheet, copies some stuff back to the main sheet (in a separate range) and all works fine.
Only problem is that the listbox then 'freezes' and doesn't look like it's responding until you move the listbox's scroll bar up and down. It is actually registering the clicks, because if I were to click on the 5th item whilst it is 'frozen', then move the scrollbar, when I get back up, the 5th item is highlighted.
It does this with and without my listfillrange code that refreshes the contents of the listbox.
Anyone know what causes this and how to get around it?
Cheers
C
It goes to another sheet, copies some stuff back to the main sheet (in a separate range) and all works fine.
Only problem is that the listbox then 'freezes' and doesn't look like it's responding until you move the listbox's scroll bar up and down. It is actually registering the clicks, because if I were to click on the 5th item whilst it is 'frozen', then move the scrollbar, when I get back up, the 5th item is highlighted.
It does this with and without my listfillrange code that refreshes the contents of the listbox.
Anyone know what causes this and how to get around it?
Cheers
C