+ Reply to Thread
Results 1 to 3 of 3

Error on procedure == Type Mismatch

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Error on procedure == Type Mismatch

    I tried to use the following code to check if the entry on the textbox is number or not.

    This works fine when its not a number (ie text) but gives error if it is left blank - Error 13 (Type mismatch) in procedure

    Please Login or Register  to view this content.
    What did I do wrong
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,872

    Re: Error on procedure == Type Mismatch

    How about this way.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Error on procedure == Type Mismatch

    It worked

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] RunTime Error 13 ( type mismatch ) error is comming TextboxAfter_Update
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2017, 03:55 AM
  2. [SOLVED] Passing array to procedure gives type mismatch error
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 08:10 AM
  3. [SOLVED] Type mismatch using worksheet object arguments in procedure
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2012, 01:35 PM
  4. Complile Error: Type Mismatch ??? After adding error trap
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2012, 03:50 PM
  5. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  6. Type mismatch when calling sub procedure..
    By christheta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2010, 12:41 PM
  7. [SOLVED] Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1