offset listbox selection

[tonyBruckner]

Given: a userform with a listbox and an ok button. The listbox lists these names:

jane doe
john doe
jill doe
jim doe

User selects jane, jane is stored in a variable. User clicks OK and an operation is performed. User is now ready for john but must select him manually.

Is there a command that will offset the listbox selection down one?

thanks in advance

[Juan Pablo González]

What do you mean by Offset in there ? remove it from the list ? select the next entry in the list ?

[Nimrod]

In a vb user form the following code was inserted into a command button. Every time the command button was clicked the selected item in the combobox was incremented by 1. Is that what your looking for ?

Private Sub CommandButton1_Click()
ComboBox1.ListIndex = ComboBox1.ListIndex + 1
End Sub

[Nimrod]

The following VB code will remove the item from the ComboBox list:

Private Sub CommandButton1_Click()
ComboBox1.RemoveItem (ComboBox1.ListIndex)
ComboBox1.ListIndex = 0
End Sub

[tonyBruckner]

Originally Posted by Juan Pablo González

What do you mean by Offset in there ? remove it from the list ? select the next entry in the list ?

by "offset" I mean move down one, selecting the next entry in the list. If the list is for instance a roll call, then names must be checked in sequence one at a time