+ Reply to Thread
Results 1 to 6 of 6

Using Application.Inputbox.........getting type mismatch error

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,429

    Using Application.Inputbox.........getting type mismatch error

    Hi, i have the following code.........


    Please Login or Register  to view this content.


    However, when i run it i get a type mismatch error at this statement........any ideas?

    err_msg_1 is defined as type string.
    Last edited by welchs101; 07-21-2011 at 07:33 AM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Using Application.Inputbox.........getting type mismatch error

    You would probably want to use a message box for showing an error because an input box is for user inputs.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,429

    Re: Using Application.Inputbox.........getting type mismatch error

    But i am requesting input from the user..........to continue or end

  4. #4
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Using Application.Inputbox.........getting type mismatch error

    Nothing was happening for me until (for some reason) I removed the Application:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,429

    Re: Using Application.Inputbox.........getting type mismatch error

    wierd one...........i fixed some other part of my code and "bam" it started working......still dont know why .......other than possibly before the fix i was referencing something that had a differnt data type..........to be honest i still dont understand....

    thanks for your help though.

  6. #6
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,429

    Re: Using Application.Inputbox.........getting type mismatch error

    i think the issue was the "prompt" text was too long. I think the max # characters is 256 or something like that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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