@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
*Sent:* Monday, February 06, 2012 9:42 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
** **
A more appropriate event for this case would be the Exit event. You can
)
If Err.Number 0 Then TextBox5.Value = ' Optional
End Sub
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Sunday, February 05, 2012 10:48 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box
Hi Asa
: $$Excel-Macros$$ vlookup in Text Box
** **
Hi Asa
Found the files see attached.
Charlie in New Zealand
On Mon, Feb 6, 2012 at 7:14 PM, Asa Rossoff a...@lovetour.info wrote:
Charlie,
Hmm… still not getting it. Maybe an Excel 2010
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
*Sent:* Saturday, February 04, 2012 10:48 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ vlookup in Text Box
** **
Hi
See attached worksheet. Excel2000
I have userform1 and one
]
On Behalf Of Cab Boose
Sent: Sunday, February 05, 2012 1:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box
Hi Asa
Have changed the two things, but now I get a 1004 error. Unable to get the
vlookup of the worksheet function class.
Note that I have
Of Cab Boose
Sent: Sunday, February 05, 2012 9:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box
Hi Asa
Workbook attached. The code is in Userform 1. Textbox 8
Thanks
Charlie
On Mon, Feb 6, 2012 at 2:43 PM, Asa Rossoff
Of *Cab Boose
*Sent:* Sunday, February 05, 2012 1:35 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
Hi Asa
Have changed the two things, but now I get a 1004 error. Unable to get
the vlookup of the worksheet function class
, 2012 10:48 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup in Text Box
Hi
See attached worksheet. Excel2000
I have userform1 and one of the codes is to lookup a part # (in Textbox
8)( say Part # 3 is to be entered here) in a named range called DBase
Once