Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rookie Here! This Code gives me a Type Mismatch Error if I try and Type
any Value in my Combo Box but if I Pick a choice from the Drop Down it works fine. What am I doing wrong? Jody Private Sub cboCmPrimaryModel_Change() Dim wo As Range Set wo = Worksheets("PrimaryToOrionMakeCode").Range("A1:B3" ) If Me.cboCmPrimaryModel.Value "" Then Label4.Caption = Application.VLookup(cboCmPrimaryModel.Value, wo, 2, False) End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error - Help Please | Excel Worksheet Functions | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
type mismatch error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |