Type mismatch Run-time Error 13

**auber** · 11-27-2009, 08:24 AM

Hi people,

I have big, big problem and i need to fix it very fast.

Every time i run user form and select value in combobox 4 i get run time error 13 type mismatch at part of code witch i will mark in code i post.

Please Login or Register  to view this content.

could somebody help me please

**Jack in the UK** · 11-27-2009, 08:35 AM

you might want to change that YELLOW text to red or something its impossible to see or read!

jiuk

**Jack in the UK** · 11-27-2009, 08:37 AM

TextBox12.Text = Application.VLookup(ComboBox4.Value, Sheets("BazaEvidencija").Range("ax6:bd13"), 7, False)

Check everything exists:
TextBox12
ComboBox4
Sheets( --- BazaEvidencja

etc

**romperstomper** · 11-27-2009, 08:58 AM

I suspect your value is not being found - try:

Please Login or Register  to view this content.

**auber** · 11-27-2009, 09:03 AM

Yes, everything exists

**auber** · 11-27-2009, 09:05 AM

thanks, but now i have same new error - Run-time error 9 Subscript out of range

I need some another solution

**Jack in the UK** · 11-27-2009, 09:15 AM

Something is missing or don’t exist -- can you post the document IF ITS NOT PRIVATE INFORMATION, don’t want you getting in trouble

Check spelling as well

jiuk

**auber** · 11-27-2009, 09:27 AM

Here is file
Error.xlsm

Now promlem is that i can not mach any value

**romperstomper** · 11-27-2009, 10:21 AM

X-post here, BTW.

You need to use:

Please Login or Register  to view this content.

**auber** · 11-27-2009, 10:46 AM

Thanks, that works perfect

Type mismatch Run-time Error 13

LinkBack

Thread Tools

Rate This Thread

Display

Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Re: Type mismatch Run-time Error 13

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions