Hi,
I know this is pretty simple but I'm struggling with it. I want to b
able to click on a command button and the combo box automatically jump
to the next item in the list. How can I do this?
Here is some "Hillbilly" code for what I am trying to accomplish:
Private Sub CommandButtonAdd_Click()
Set wa = Me.ComboBoxJumpToPart.Value
Set wb = Range("PartsList")
'find the (wa) .value in (wb)
'and set (wa) to the next item in the (wb) list.
End Sub
Any help is appreciated.
Jod
--
ssjod
-----------------------------------------------------------------------
ssjody's Profile:
http://www.excelforum.com/member.php...fo&userid=3339
View this thread:
http://www.excelforum.com/showthread.php?threadid=56481