RienTimmer
New member
- Local time
- Today, 10:40
- Joined
- Jun 30, 2008
- Messages
- 3
Hi,
I have a listbox on a form where I use the Extended multi-select.
After selecting multiple values I hit a button and my VBA code starts processing the selected rows, deselecting the rows as they are processed.
During this process the listbox displays as I last used it i.e. it does now reflect the row being processed and does not move; you see the rows being deselected as the processing progresses through the rows displayed in the box.
Is it possible to have the listbox display a 'current' row, i.e. scroll the box from VBA?
Something like:
Me.lstRecipients.Selected(row) = False
Me.lstRecipients.Display?=row
Me.lstRecipients.ScrollDown?
I have a listbox on a form where I use the Extended multi-select.
After selecting multiple values I hit a button and my VBA code starts processing the selected rows, deselecting the rows as they are processed.
During this process the listbox displays as I last used it i.e. it does now reflect the row being processed and does not move; you see the rows being deselected as the processing progresses through the rows displayed in the box.
Is it possible to have the listbox display a 'current' row, i.e. scroll the box from VBA?
Something like:
Me.lstRecipients.Selected(row) = False
Me.lstRecipients.Display?=row
Me.lstRecipients.ScrollDown?