error trapping

  1. kelly mort

    VBA: IsNumeric Function Returning True Even If Data Contains Letters. Any Other Way To Validate Entry?

    I am using an inputbox to assign value(s) to my variable. After that I use the IsNumeric Function to check if the entry is a valid number. During the testing process, I realized that I mistakenly entered 4e4 and instead of the function flagging that out as an invalid number, it went through as...
  2. ClimoC

    ADO Conn to csv - error trapping suggestion?

    How would you do this? strsql1 = "SELECT * From " & fName StatsForm.TextBox1.Value = StatsForm.TextBox1.Value & " querying " & fName & "..." DoEvents On Error GoTo oops Err.Clear If Not FPRSet Is Nothing Then Set FPRSet = Nothing With cnImportConn1...
  3. V

    Error 400 Appears and Then Goes Away On Its Own

    Hi all! I'm really hoping that someone will be able to help me out with my dilemma. I've built a spreadsheet that draws a cross-section and then calculates a bunch of properties based on it's dimensions. In a nutshell, you enter in the dimensions, select the cross-section type (three to...
    • valenteen
    • Thread
    • application defined error error 400 error trapping object defined error
    • Replies: 3
    • Forum: Excel Questions
  4. A

    Error Trapping Gives me Errors.....

    Hi All, I have some error trapping that I've been using that has worked great in the past, but for some reason, it suddenly stopped working. I had to add in some code and I always make sure to use On Error Goto 0 to disable the trap I just set. Towards the end of my macro, there's a line of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top