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: use sumproduct formula to find min & max values

2013-10-30 Thread Rajan sharma
Hi, CSE stands for Control + Shift + Enter ( Enter in same time after entering the formula) With warm regards, Rajan Sharma On Thu, Oct 31, 2013 at 10:20 AM, kasper wrote: > Hi > > Thanks for the formula, but the formula is not working for me. What is > "with cse" > > Rgards > Rajesh > > O

$$Excel-Macros$$ Re: use sumproduct formula to find min & max values

2013-10-30 Thread kasper
Hi Thanks for the formula, but the formula is not working for me. What is "with cse" Rgards Rajesh On Wednesday, October 30, 2013 5:08:00 PM UTC+5:30, kasper wrote: > > Hi Experts > > Please refer the attached document and tell me how can I get the min > and max values of each month from the

RE: $$Excel-Macros$$ data cleansing

2013-10-30 Thread Pehrson, Dave
Thanks for very much, that was just what I was looking for. Best Regards Dave From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Tuesday, October 29, 2013 6:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ data cleansi

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

Re: $$Excel-Macros$$ use sumproduct formula to find min & max values

2013-10-30 Thread Rajan sharma
Hi, Try Below for Min =MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE for Max =MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE With warm regards, Rajan Sharma On Wed, Oct 30, 2013 at 5:08 PM, Rajesh thrissur wrote: > Hi Experts > > Please refer the attached docu

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$$ use sumproduct formula to find min & max values

2013-10-30 Thread Rajesh thrissur
Hi Experts Please refer the attached document and tell me how can I get the min and max values of each month from the given data using sumproduct or any other methode suitable to that. Regards Rajesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

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

Re: $$Excel-Macros$$ Formula for Lookup Based on 3-Factors Rather than Helper Columns

2013-10-30 Thread JohnA
Anoop, It really does help me, thank you. I don't understand it, but will be looking at the structure to learn how it works. Again, thank you for your quick reply and your much appreciated help. John On Wednesday, October 30, 2013 1:29:07 AM UTC-4, Enrique Martin wrote: > > Hi John, > > Pleas