run-time error '13' type mismatch visual basic

**Michell Feitosa** · 09-22-2012, 11:28 PM

Hello,

I'm a very beginner user of macros, and when a erro comes up, I have no idea how to fix it. Could you guys help me?

I have a macro to add row or delete rows to the table, and I'm using a message box to do it.
The problem is, when I select the option "Cancel" the "run-time error '13' " type mismatch, comes up. And when I degub it, the line " MyInput = InputBox(Msg, Title)" is selected in yellow.

how to fix it?

Please Login or Register  to view this content.

Thanks in advance

Michell

**nilem** · 09-23-2012, 12:38 AM

try it

Please Login or Register  to view this content.

**Michell Feitosa** · 09-23-2012, 06:28 AM

It was just brilliant Nilem.

Thank you so much.

By the way, Im struggling with the cod to delete the last row of my table, do you have any suggestion. It's going to be in the same macro above.

Michell

**nilem** · 09-23-2012, 08:13 AM

hi Michell, try something like this

Please Login or Register  to view this content.

**Michell Feitosa** · 09-23-2012, 07:42 PM

yeah its work!!!!

Thanks a billion Nilem

run-time error '13' type mismatch visual basic

LinkBack

Thread Tools

Rate This Thread

Display

run-time error '13' type mismatch visual basic

Re: run-time error '13' type mismatch visual basic

Re: run-time error '13' type mismatch visual basic

Re: run-time error '13' type mismatch visual basic

Re: run-time error '13' type mismatch visual basic

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions