Excel VBA Run-time error '13' Type mismatch

**svibuk** · 04-30-2014, 04:58 AM

i have a excl workbook with sheet1 & mastersheet

in Master sheet i have defined values in list Column D & F
Column D has COUNTRY as heading and country Names below it
Column F has CITY and city list

Im column A i have 2 data list
as

COUNTRY
CITY

i have dropdown in excel sheet (SHEET1) in Column K populated with data from MASTER in Column A ie city & country

When i select city i need Dropdown in column L to be populated with Citylist from MASTERS COLUMN F and if city seleced i need to get data from column D
but i get type mismatch error

Please Login or Register  to view this content.

**Kaper** · 04-30-2014, 05:13 AM

and what is Range("CST") ?
and which line highlights while debugging?

**svibuk** · 04-30-2014, 05:47 AM

sry its country
PartNoRow = Application.Match(.Value, wsLists.Range("COUNTRY"), 0) i get error after this
i think its not giving a integer value for PartNoRow
if i hardcode PartNoRow =1
i dont get the mismatch error

2) how do i bind data to dropdown i have created this dropdown from my application code not from vba

i have
For Each cPart In wsLists.Range("CITY")
.Offset(0, 1).Value = cPart.Value
MsgBox (cPart.Value)
Next cPart

i get the different value but not able to fill the dropdown in thet cell

**Norie** · 04-30-2014, 05:55 AM

It sounds like Application.Match hasn't found a match and is returning an error.

If that's the case and you've declared PartNoRow as an (Long?) Integer then you'll get a Type Mismatch.

To prevent the error declare as Variant instead of Integer.

If there's definitely a match then you'll need to find out why Application
Match is returning an error.

**Kaper** · 04-30-2014, 05:56 AM

1) use code tags - see forum rules why (you know how-to). edit your post.
2)

Please Login or Register  to view this content.

so in next code line you de facto do

Please Login or Register  to view this content.

is it right?

**svibuk** · 04-30-2014, 06:04 AM

Please Login or Register  to view this content.

yes in .value i get COUNTRY or CITY whichever is selected
even if i use it directly i get error

**Norie** · 04-30-2014, 06:53 AM

What is this supposed to reference?

Please Login or Register  to view this content.

**svibuk** · 05-01-2014, 04:23 AM

Country is a defined name for a range of cells which contains country names

Excel VBA Run-time error '13' Type mismatch

LinkBack

Thread Tools

Rate This Thread

Display