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

**welchs101** · 07-18-2011, 01:19 PM

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

err_msg_1 = Application.InputBox("The input file checking procedure has detected what could possibly be an error with input file.  A required Header string was not found.  Do you wish to ignore this and continue with running the program or do you wish to end the program now?  (C)ontinue or (E)nd")

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

err_msg_1 is defined as type string.

**Mordred** · 07-18-2011, 01:22 PM

You would probably want to use a message box for showing an error because an input box is for user inputs.

**welchs101** · 07-18-2011, 01:28 PM

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

**Mordred** · 07-18-2011, 01:30 PM

Nothing was happening for me until (for some reason) I removed the Application:

err_msg_1 = InputBox("The input file checking procedure has detected what could possibly be an error with input file.  " _
 & "A required Header string was not found.  Do you wish to ignore this and continue with running " _
 & "the program or do you wish to end the program now?  (C)ontinue or (E)nd")

**welchs101** · 07-18-2011, 01:55 PM

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.