vlookup in combobox

[Gary Keramidas]

combobox change event:

can someone tell me the syntax to do a vlookup of one combobox in a range on
a sheet and populate another combobox or textbox in that same form?

or is there another way to do this?

--


Gary

[Norman Jones]

Hi Gary,

See xlDynamic's Dependent Dropdowns page:

http://www.xldynamic.com/source/xld.Dropdowns.html


---
Regards,
Norman



"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
> combobox change event:
>
> can someone tell me the syntax to do a vlookup of one combobox in a range
> on a sheet and populate another combobox or textbox in that same form?
>
> or is there another way to do this?
>
> --
>
>
> Gary
>
>
>

[Gary Keramidas]

isn't there something simple like this?
Application.Evaluate("=VLookup(userform1.Acct1, acctnum, 1, False)")

--


Gary


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:uSclC1s9FHA.3592@TK2MSFTNGP12.phx.gbl...
> Hi Gary,
>
> See xlDynamic's Dependent Dropdowns page:
>
> http://www.xldynamic.com/source/xld.Dropdowns.html
>
>
> ---
> Regards,
> Norman
>
>
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
>> combobox change event:
>>
>> can someone tell me the syntax to do a vlookup of one combobox in a range
>> on a sheet and populate another combobox or textbox in that same form?
>>
>> or is there another way to do this?
>>
>> --
>>
>>
>> Gary
>>
>>
>>
>
>

[Norman Jones]

Hi Gary,

If your intention is to load a combobox depending on the vlaue of another
combobox, then I would again advocate that you look at the techniques
described by Bob Phillips at the suggested link.

I have frequently adopted similar approaches without problem. Perhaps,
however, I have misunderstood what you are endeavouring to do.

---
Regards,
Norman


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:eWv1M4s9FHA.1020@TK2MSFTNGP15.phx.gbl...
> isn't there something simple like this?
> Application.Evaluate("=VLookup(userform1.Acct1, acctnum, 1, False)")
>
> --
>
>
> Gary
>
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:uSclC1s9FHA.3592@TK2MSFTNGP12.phx.gbl...
>> Hi Gary,
>>
>> See xlDynamic's Dependent Dropdowns page:
>>
>> http://www.xldynamic.com/source/xld.Dropdowns.html
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>>
>> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
>> news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
>>> combobox change event:
>>>
>>> can someone tell me the syntax to do a vlookup of one combobox in a
>>> range on a sheet and populate another combobox or textbox in that same
>>> form?
>>>
>>> or is there another way to do this?
>>>
>>> --
>>>
>>>
>>> Gary
>>>
>>>
>>>
>>
>>
>
>

[Gary Keramidas]

norman:

sorry if it was unclear, just wanted to lookup a name from an account
number that was entered into a combobox. the acct number are on a separate
sheet in columns a and b.

my posted code seems to work fine

--


Gary


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:%23Rk8HBt9FHA.1440@TK2MSFTNGP12.phx.gbl...
> Hi Gary,
>
> If your intention is to load a combobox depending on the vlaue of another
> combobox, then I would again advocate that you look at the techniques
> described by Bob Phillips at the suggested link.
>
> I have frequently adopted similar approaches without problem. Perhaps,
> however, I have misunderstood what you are endeavouring to do.
>
> ---
> Regards,
> Norman
>
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:eWv1M4s9FHA.1020@TK2MSFTNGP15.phx.gbl...
>> isn't there something simple like this?
>> Application.Evaluate("=VLookup(userform1.Acct1, acctnum, 1, False)")
>>
>> --
>>
>>
>> Gary
>>
>>
>> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
>> news:uSclC1s9FHA.3592@TK2MSFTNGP12.phx.gbl...
>>> Hi Gary,
>>>
>>> See xlDynamic's Dependent Dropdowns page:
>>>
>>> http://www.xldynamic.com/source/xld.Dropdowns.html
>>>
>>>
>>> ---
>>> Regards,
>>> Norman
>>>
>>>
>>>
>>> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
>>> news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
>>>> combobox change event:
>>>>
>>>> can someone tell me the syntax to do a vlookup of one combobox in a
>>>> range on a sheet and populate another combobox or textbox in that same
>>>> form?
>>>>
>>>> or is there another way to do this?
>>>>
>>>> --
>>>>
>>>>
>>>> Gary
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

[Norman Jones]

Hi Gary,

Thank you for the additional explanation.


---
Regards,
Norman



"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:%23nGgPZt9FHA.2696@TK2MSFTNGP11.phx.gbl...
> norman:
>
> sorry if it was unclear, just wanted to lookup a name from an account
> number that was entered into a combobox. the acct number are on a separate
> sheet in columns a and b.
>
> my posted code seems to work fine
>
> --
>
>
> Gary
>
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:%23Rk8HBt9FHA.1440@TK2MSFTNGP12.phx.gbl...
>> Hi Gary,
>>
>> If your intention is to load a combobox depending on the vlaue of another
>> combobox, then I would again advocate that you look at the techniques
>> described by Bob Phillips at the suggested link.
>>
>> I have frequently adopted similar approaches without problem. Perhaps,
>> however, I have misunderstood what you are endeavouring to do.
>>
>> ---
>> Regards,
>> Norman
>>
>>
>> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
>> news:eWv1M4s9FHA.1020@TK2MSFTNGP15.phx.gbl...
>>> isn't there something simple like this?
>>> Application.Evaluate("=VLookup(userform1.Acct1, acctnum, 1, False)")
>>>
>>> --
>>>
>>>
>>> Gary
>>>
>>>
>>> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
>>> news:uSclC1s9FHA.3592@TK2MSFTNGP12.phx.gbl...
>>>> Hi Gary,
>>>>
>>>> See xlDynamic's Dependent Dropdowns page:
>>>>
>>>> http://www.xldynamic.com/source/xld.Dropdowns.html
>>>>
>>>>
>>>> ---
>>>> Regards,
>>>> Norman
>>>>
>>>>
>>>>
>>>> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
>>>> news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
>>>>> combobox change event:
>>>>>
>>>>> can someone tell me the syntax to do a vlookup of one combobox in a
>>>>> range on a sheet and populate another combobox or textbox in that
>>>>> same form?
>>>>>
>>>>> or is there another way to do this?
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>> Gary
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

[Gary Keramidas]

this seems to work for my needs

p1 = Me.Acct1.Value
Me.Player1.Value = Application.Evaluate("=VLookup(" & p1 & ", acctnum, 2,
False)")


--


Gary


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:uSclC1s9FHA.3592@TK2MSFTNGP12.phx.gbl...
> Hi Gary,
>
> See xlDynamic's Dependent Dropdowns page:
>
> http://www.xldynamic.com/source/xld.Dropdowns.html
>
>
> ---
> Regards,
> Norman
>
>
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:%23MxtTys9FHA.600@tk2msftngp13.phx.gbl...
>> combobox change event:
>>
>> can someone tell me the syntax to do a vlookup of one combobox in a range
>> on a sheet and populate another combobox or textbox in that same form?
>>
>> or is there another way to do this?
>>
>> --
>>
>>
>> Gary
>>
>>
>>
>
>