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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>