Type mismatch (Error 13)

**JDM-007** · 02-20-2018, 05:20 PM

Hi Guys,

I have the problems with this code:

I want if you select in the excelspace (combo) the text "Uitplakprofiel Z-vormig", i want that the variable omlijstingdikte changes to 6.
I need this 6 to make further calculations. I Took dim as variant because i work with a range of cells and variant can act like an array.
When i run the program, i get always the same error: Type mismatch (Error 13)
The problem is situated at If omlijsting = "Uitplakprofiel Z-vormig" Then excel said.

Can somebody clear this out please? because i struggle with it in another module also.

Please Login or Register  to view this content.

Sorry for the bad English

Thanks in advance

**shg** · 02-20-2018, 05:20 PM

Welcome to the board.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

**shg** · 02-21-2018, 11:17 AM

Thanks for the code tags.

In this statement,

Please Login or Register  to view this content.

omlijsting is a 2D array; you can't compare it to a single value.

**JDM-007** · 02-21-2018, 12:00 PM

Hi,

thanks for the feedback but i 'm a newbie to vba so i understand that this are different types of value. But what is a good workaround/workflow to deal with it?

Thanks in advance

**Norie** · 02-21-2018, 12:19 PM

O17:Q17 is merged, which means only O17 actually has a value, so try this.

Please Login or Register  to view this content.

**bakerman2** · 02-21-2018, 12:22 PM

Q17 is partof a merged cell so it has to be O17 instead of Q17.

PS My apologies Norie, should have pressed F5 before posting.

**JDM-007** · 02-21-2018, 05:11 PM

Hi,

That works fine thanks for it. I change this also in module 2 (also merged cells).

Please Login or Register  to view this content.

Now the problem is i want to use the value 6 (because omlijstingdikte=6) that i became at module 3 (Sub omlijsting_check()) in the calculation at module 2
for deurbladhoogte = hoogte_gat - omlijstingdikte - houtdikte - speling_deurVSkassement - speling_onder_deur.

Can somebody tell what's the best approach?

Thanks in advance

**bakerman2** · 02-22-2018, 02:32 AM

Your Module3 would look like this.Option Explicit

Please Login or Register  to view this content.

Your Module2 like this

Please Login or Register  to view this content.

Also it's not very wise to declare all variables as Variant because they are the most memory consuming.

**JDM-007** · 02-22-2018, 12:21 PM

Hi,

thanks, i change the variabletypes.

**bakerman2** · 02-22-2018, 12:48 PM

Glad to help and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Type mismatch (Error 13)

LinkBack

Thread Tools

Rate This Thread

Display

Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Re: Type mismatch (Error 13)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] RunTime Error 13 ( type mismatch ) error is comming TextboxAfter_Update

Run Type error 13 Type Mismatch

[SOLVED] Run-type error 13 type mismatch

Complile Error: Type Mismatch ??? After adding error trap

Conditional Formatting - Run Time Error '13' Type Mismatch Error

[SOLVED] re: Type Mismatch Error

[SOLVED] Help: Compile error: type mismatch: array or user defined type expected

Bookmarks

Bookmarks

Posting Permissions