Re: $$Excel-Macros$$ VlookUp VBA : Can't link up with a Text Box

2013-10-30 Thread Rupesh Patil
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

$$Excel-Macros$$ VlookUp VBA : Can't link up with a Text Box

2013-10-30 Thread TAWHID
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