hi Sam,

Right click on the userform in the VBE & select Tab Order. You can see
the 2 below links for more details:
'Excel -- UserForm With ComboBoxes'
(http://www.contextures.com/xlUserForm02.html#Test)
'VBA for Excel Userforms'
(http://www.excel-vba.com/vba-forms-3-1-creating.htm)

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113134