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

2013-10-31 Thread TAWHID
Wow! Its working. Thanks a lot! On Wednesday, 30 October 2013 11:42:27 UTC+1, 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 Variant > Dim rng As Range

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

2013-10-30 Thread Tawhidul Hamid
Hi Rupesh, Clicking the count button is enabling the macro. No? Cheers On Thu, Oct 31, 2013 at 7:36 AM, Rupesh Patil wrote: > I have question over here how could userfrom show before without enable > micro. > > Thanks Rupesh > > > On Thu, Oct 31, 2013 at 11:48 AM, TAWHID wrote: > >> OMG! The P

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

2013-10-30 Thread TAWHID
Hi Rupesh, Clicking the count button is enabling the macro. No? Cheers On Wednesday, 30 October 2013 11:42:27 UTC+1, 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() > > D

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

2013-10-30 Thread Rupesh Patil
I have question over here how could userfrom show before without enable micro. Thanks Rupesh On Thu, Oct 31, 2013 at 11:48 AM, TAWHID wrote: > OMG! The Pic become to text !! print screen attached > > > On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: >> >> Can anyone let me know wha

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

2013-10-30 Thread Rupesh Patil
Dear Tawhid, I have checked this ("When I put an item code in textbox1 it says item not found instead of showing it in the description. ") out and your code is working fine. I have enter item code in textbox1 and got there description in next to the textbox1 label Thanks Rupesh On Thu, Oct 31,

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

2013-10-30 Thread TAWHID
When I put an item code in textbox1 it says item not found instead of showing it in the description. Thanks On Wednesday, 30 October 2013 11:42:27 UTC+1, 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

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

2013-10-30 Thread Anoop K Sharma
Your code is working fine. What error code you are getting there? On Wed, Oct 30, 2013 at 6:32 PM, TAWHID wrote: > Dear Rupesh , > Thanks for your quick reply. > > Please have look the attachemnt. > > If I press the "count" batton, the form appears. I am putting > (copy/paste) item code in t