$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box
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
> 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
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
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
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
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
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: VlookUp VBA : Can't link up with a Text Box
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.
