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
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 Option Explicit at top of page, do I need to declare anything ? Thanks Charlie On Sun, Feb 5, 2012 at 8:20 PM, Asa Rossoff wrote: > Hi Charlie, >

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

2012-02-04 Thread Asa Rossoff
Hi Charlie, Glad my last post helped :) >From a quick look I see two issues/potential issues: 1. The syntax error: TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range.("DBase"),2,False) Remove the "." between "Range" and ("Dbase"): TextBox5.Value = WorksheetFunction.VLoo