$$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 =

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 tawhid.ha...@gmail.com 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