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