Dear tawhid
I tried your code, I don't any error.
thanks Rupesh
On Wed, Oct 30, 2013 at 4:12 PM, TAWHID wrote:
> Can anyone let me know whats wron in this code below? When I run it says
> error in this line: Set lookFor = Me.TextBox1
>
> Private Sub TextBox1_Change()
>
> Dim lookFor As Varian
Can anyone let me know whats wron in this code below? When I run it says
error in this line: Set lookFor = Me.TextBox1
Private Sub TextBox1_Change()
Dim lookFor As Variant
Dim rng As Range
Dim col As Integer
Dim found As Variant
Set lookFor = Me.TextBox1
Set rng = Sheets("MSR_Input").Columns("A