| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro crashes if an entry in a combo box is not in the list
I am using a combo box on a form to find a part in a list, if the combo is
left empty a message is displayed. the code is as follows If Trim(Me.cboPart.Value) = "" Then Me.cboPart.SetFocus MsgBox "Please enter a part number" Exit Sub End If But if I enter a number not on the list, the debug window pops up. I can not seem to find the syntax to say 'If the combo value finds no match then show error message'. I would think it is just a case of putting the 'no match' in place of the "" I am greatful for any pointers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
| Combo Box that allows user entry of values not on drop-down list | Excel Discussion (Misc queries) | |||
| select macro within combo box or list box to | Excel Discussion (Misc queries) | |||
| What happened to my Macro entry in the Excel 2003 Tool menu list? | Setting up and Configuration of Excel | |||
| Excel crashes when Combo Box loses focus | Excel Programming | |||
Threaded Mode
