I want to use the following formula in my excel sheet to extract the words in the square bracket. It works fine.
Code: Select all
=MID(V9,FIND("[",V9)+1,FIND("]",V9)-FIND("[",V9)-1)
Code: Select all
Private Sub CommandButton1_Click()
Me.txtStatus.Value = "=MID(txt.Name,FIND("[",txt.Name)+1,FIND("]",txt.Name)-FIND("[",txt.Name)-1)"
End Sub