Thread: [Solved] Using combobox to pass data from an Excel spread sheet to text boxes on userform
View Single Post
 
Old 12-17-2015, 08:32 PM
Stewie840 Stewie840 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Dec 2015
Posts: 8
Stewie840 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
Perhaps, then you need to consider why you're using a combobox instead of a ListBox, so they can only choose from the valid records.
Paul, the reason I am not using a list box is...there are around 2000 IDs and I want the user to start typing the ID number.

If they accidentially type the wrong number I get the run-time error(381).

So now the question is how do I handle that error and reset the form to type the correct number in.

Hope that is clearer than mud.

Cheers

Stewie
Reply With Quote