Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-07 Thread Sam Mathai Chacko
From:* excel-macros@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 a

Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-06 Thread Sam Mathai Chacko
ox8.Value), > Range("DBase"), 2, False) > > If Err.Number <> 0 Then TextBox5.Value = "" ' Optional > > End Sub > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-

RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-06 Thread Asa Rossoff
r file? Can you right-click the userform and select Export File... then send the resulting .frm and .frx files? Thanks, Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Sunday, February 05, 2012 9:10 PM To: excel-macros@googlegr

Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Cab Boose
ode I can better tell what might be going on. > > > > Asa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Sunday, February 05, 2012 1:35 PM > *To:* excel-macros@googlegroups.com > *

RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Asa Rossoff
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 wrote: Hi

RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Cab Boose
ther workbook---that which is > on-screen at any given moment. Avoid pitfalls that way. Whoops :) > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Saturday, February 04, 2012 1

RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-04 Thread Asa Rossoff
oglegroups.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 of the codes is to lookup a part # (in Textbox 8)( say Part #