Learn MS Excel – Video 404- VBA – Extract numbers from string – Function with error handller



Terrific program where we used loops in subloops. We also used mid function with error handler in this extremely advance video. We learnt how to make a macro which can get the numbers extracted from any string which has mixture of numbers and special charts or text values.

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

6 thoughts on “Learn MS Excel – Video 404- VBA – Extract numbers from string – Function with error handller

  1. Inputdata

    P2023
    SdP122
    p2366

    I am trying to write a dummy code that does this:

    =if(left(A1,1)="P",1,0)

    My code:

    Sub Button1_Click()
    If Left(Range("A1"), 1) = ""P"" Then
    Range("B1") = 1
    Else
    Range("B1") = 0
    End If
    End Sub

    Question. Is VBA code case sensitive. When i input this P2023 in A1 i get 1 as out put, but when i use small letter p i.e p2023, i get 0. Please assist

Leave a Reply

Your email address will not be published. Required fields are marked *