date:20131030

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 Pic become to text !! print screen attached
>>
>>
>> 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
>>> Dim col As Integer
>>> Dim found As Variant
>>>
>>> Set lookFor = Me.TextBox1
>>> Set rng = Sheets("MSR_Input").Columns("**A:C")
>>> col = 2
>>>
>>> On Error Resume Next
>>> found = Application.VLookup(lookFor, rng, col, 0)
>>> If IsError(found) Then
>>> MsgBox lookFor & " not found"
>>> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of "
>>> & lookFor & " is " & found & " in column " & col
>>>
>>> End If
>>> On Error GoTo 0
>>>
>>> End Sub
>>>
>>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Thanks and Regards, Rp.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/iwxUONCQ1NI/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://group

$$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()
>
> 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:C")
> col = 2
>
> On Error Resume Next
> found = Application.VLookup(lookFor, rng, col, 0)
> If IsError(found) Then
> MsgBox lookFor & " not found"
> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of " & 
> lookFor & " is " & found & " in column " & col
>
> End If
> On Error GoTo 0
>
> End Sub
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 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:C")
>> col = 2
>>
>> On Error Resume Next
>> found = Application.VLookup(lookFor, rng, col, 0)
>> If IsError(found) Then
>> MsgBox lookFor & " not found"
>> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of "
>> & lookFor & " is " & found & " in column " & col
>>
>> End If
>> On Error GoTo 0
>>
>> End Sub
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Thanks and Regards, Rp.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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, 2013 at 10:24 AM, TAWHID  wrote:

> 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
>>
>> 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:C")
>> col = 2
>>
>> On Error Resume Next
>> found = Application.VLookup(lookFor, rng, col, 0)
>> If IsError(found) Then
>> MsgBox lookFor & " not found"
>> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of "
>> & lookFor & " is " & found & " in column " & col
>>
>> End If
>> On Error GoTo 0
>>
>> End Sub
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Thanks and Regards, Rp.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$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
>
> 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:C")
> col = 2
>
> On Error Resume Next
> found = Application.VLookup(lookFor, rng, col, 0)
> If IsError(found) Then
> MsgBox lookFor & " not found"
> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of " & 
> lookFor & " is " & found & " in column " & col
>
> End If
> On Error GoTo 0
>
> End Sub
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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
>
> 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 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:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$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 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:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 cleansing

You can use =trim() formula to remove the blanks in end of the word or starting 
of the word.
On 30-Oct-2013 4:37 AM, "Pehrson, Dave" 
mailto:dpehr...@walbro.com>> wrote:
I have a situation where I down load data and delineate results leaving a name 
with blanks behind the number making a Vlookup difficult.

ASIAN HONDA MOTOR CO.,LTD.

The name above is an example.  Is there a formula I can use to remove any 
blanks behind the last character?

Your help as always is appreciated.

Regards

Dave

Visit
http://www.excelvbamacros.com/

P Before printing, think about the environment.

--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem,

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 the text box (Item code), it should Vlookup the
> description next to the text box in the label.
>
>
> Cheers,
> Tawhid
>
> 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
>> Dim col As Integer
>> Dim found As Variant
>>
>> Set lookFor = Me.TextBox1
>> Set rng = Sheets("MSR_Input").Columns("**A:C")
>> col = 2
>>
>> On Error Resume Next
>> found = Application.VLookup(lookFor, rng, col, 0)
>> If IsError(found) Then
>> MsgBox lookFor & " not found"
>> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of "
>> & lookFor & " is " & found & " in column " & col
>>
>> End If
>> On Error GoTo 0
>>
>> End Sub
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 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:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 Variant
> Dim rng As Range
> Dim col As Integer
> Dim found As Variant
>
> Set lookFor = Me.TextBox1
> Set rng = Sheets("MSR_Input").Columns("A:C")
> col = 2
>
> On Error Resume Next
> found = Application.VLookup(lookFor, rng, col, 0)
> If IsError(found) Then
> MsgBox lookFor & " not found"
> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of " &
> lookFor & " is " & found & " in column " & col
>
> End If
> On Error GoTo 0
>
> End Sub
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Thanks and Regards, Rp.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$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:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


BSE30   (1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$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:C")
col = 2

On Error Resume Next
found = Application.VLookup(lookFor, rng, col, 0)
If IsError(found) Then
MsgBox lookFor & " not found"
Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of " & 
lookFor & " is " & found & " in column " & col

End If
On Error GoTo 0

End Sub

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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,
>
> Please find attached and locate your answer on tab "Division2".
> I hope, it'll help you.
>
> have a great day!!
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Tue, Oct 29, 2013 at 8:00 PM, John A. Smith 
> 
> > wrote:
>
>> I need help with a formula that will examine three factors and return the 
>> associated value.
>>  DOWNLOAD:   Indicator *Division* *Jan-13* *Feb-13*   
>> Indicator1-Sales Division1 209 301  Indicator1-Sales Division2 523 126  
>> Indicator1-Sales Division3 267 334  Indicator2-COGS Division1 107 272  
>> Indicator2-COGS Division2 212 44  Indicator2-COGS Division3 146 122  
>> Indicator3-Misc 
>> Rev Division1 10 15  Indicator3-Misc Rev Division2 19 108  Indicator3-Misc 
>> Rev Division3 49 102   
>> The download I need to use as a lookup table has multiple facilities 
>> meaning the lookup has to take into account the facility (row data), the 
>> indicator (row data) and the month (column heading). Please see attached 
>> spreadsheet for a detailed example...
>>  
>> I use helper columns by connecting the facility and indicator (making a 
>> unique value to lookup).
>>  
>> It would a lot faster overall to be able to use a single formula and I am 
>> anxious to learn what it is...
>>  
>> My personal thanks to the group for the excellent work they do and have 
>> done!
>>  
>> --
>> John
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> -- 
> Regards,
> Anoop
> Sr. Developer
> Facebook ID - https://www.facebook.com/anooop.k.sharma
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

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

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

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

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

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

RE: $$Excel-Macros$$ data cleansing

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

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

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

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

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

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

14 matches

Site Navigation

Mail list logo

Footer information