Home
Blogs
Questions
Jobs
Monetize

Home

About Us

Blogs

Questions

Jobs

Monetize

Post Job

banner

Questions about mismatch

Read more about mismatch

python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mismatch

Runtime Error '13' Type Mismatch clicking Cancel on VBA Input Box

I am using an input box to pass a value to a stored procedure. However, when I click cancel I get a Runtime Error '13' Type Mismatch error. I tried to include an exit sub command but it hasn't worked....
test-img

Darren Wardill

vba

types

runtime

mismatch

Votes: 0

Answers: 2

Latest Answer

InputBox returns a string. When you press Cancel it returns "" which isn't a number, so you get the error (you'd get the same error if you entered text and hit OK). Maybe use two variables -...
test-img

Darren Bartrup-Cook

Posts

Questions

Blogs

Jobs

The ultimate platform for coders and IT specialists

About

  • Company
  • Support

  • Platform

  • Terms & Conditions
  • Privacy statement
  • Cookie policy
  • Cookie option
  • OnlyCoders © 2025  |  All rights reserved