Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
I have two issues with a listbox.
1) I have a userform, which has a multipage on it, on the multipage there is a listbox. The listbox shows the results from sheet2, when the code is run, the sheet is populated and the results show in the listbox. As the update is rapid, the list box flickers. I have tried to add, but this is not having any luck and the flickering is still there.
Does anyone know if there is a way to stop the flickering?
2) As the list box is updating I can not scroll up or down or across, until it has finished populating. Have I missed something in the listbox propeties?
Thanks
1) I have a userform, which has a multipage on it, on the multipage there is a listbox. The listbox shows the results from sheet2, when the code is run, the sheet is populated and the results show in the listbox. As the update is rapid, the list box flickers. I have tried to add, but this is not having any luck and the flickering is still there.
VBA Code:
Application.ScreenUpdating = False
'My code
Application.ScreenUpdating = True
Does anyone know if there is a way to stop the flickering?
2) As the list box is updating I can not scroll up or down or across, until it has finished populating. Have I missed something in the listbox propeties?
Thanks