Thanks Daniel it works
Thanks Dave too
S baloo
On Tue, Jul 7, 2009 at 7:36 PM, Daniel wrote:
> Hello.
>
> The following code works :
>
>
>
> Private Sub ComboBox1_Change()
>
> Result = Application.VLookup(CDbl([Sheet1].ComboBox1.Value), _
>
> [Sheet1!Q1:W100], 6, 0)
>
> End Sub
>
>
>
> HT
Hello.
The following code works :
Private Sub ComboBox1_Change()
Result = Application.VLookup(CDbl([Sheet1].ComboBox1.Value), _
[Sheet1!Q1:W100], 6, 0)
End Sub
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Balachander S
Envoyé :
Could you post a sample file ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Balachander S
Envoyé : dimanche 5 juillet 2009 18:11
À : excel-macros@googlegroups.com
Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: V look up error 1004
Attn
Hi,
Assuming accno is a named range, try one of the following:
WorksheetFunction.VLookup(("accno"), Range("q4:w570"), 5, False)
or
WorksheetFunction.VLookup(Range(accno), Range("q4:w570"), 5, False)
or
WorksheetFunction.VLookup(Range("accno"), Range("q4:w570"), 5, False)
Regards - Dave.
Date: S
Attn Daniel
Range q 4 w 570 contains digits
Changed the code to DBL
same error 1004 :"unable to get the Vlook property of the worksheet function
class"
Same error
Any other suggestions
S Baloo
On Sun, Jul 5, 2009 at 9:32 PM, Daniel wrote:
> « 'accno = ComboBox3.Value »
>
>
>
> Comboboxes r
« 'accno = ComboBox3.Value »
Comboboxes return string value ; if « Range("q4:w570") » contains digits,
you may have this error.
Change to :
accno = cdbl(ComboBox3.Value)
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Balachander S
E
