Vlookup on Userform

[D_N_L]

Hi all,

I can't see what is wrong with my code:

MyRange is a two column table on Sheet1 (an actual XL table). I have it firing as a 'Userform_initialize' event if that matters?

Please Login or Register  to view this content.

[Norie]

What is wrong with the code?

Are you getting errors? Incorrect results?

[D_N_L]

Hi Norie,

Apologies, that was an oversight. I receive the RTE 1004 (application/object undefined error).

On the whole line...

[romperstomper]

How can your combobox have a value when the form is being loaded?

What's MyRange - the address of a range or a Range object?

[D_N_L]

That's true. I never thought of that. MyRange is reference to an Excel Table (excluding the headers).

[romperstomper]

If it's a Range object, then you just use:

Please Login or Register  to view this content.

but of course that won't fix the other issue.

[D_N_L]

I see. Thanks romper - I'll sort the other issue out. I'll connect it to a Multipage_change event or something.

[romperstomper]

You could have other code in the Initialize event to assign a value to the combobox - just depends what you're trying to achieve.

[D_N_L]

What I am trying to do is:

• User selects a value from a ComboBox1
• Textbox1 is populated according to vLU based upon value in CB1

I tried assigning it to ComboBox1_Change() event but I got a RTE13 'Type error mismatch'

[romperstomper]

That probably means the value isn't being found - what kind of data is it - numeric/date/text?

[D_N_L]

Alphanumreric.

[romperstomper]

Can you post a sample workbook?

[D_N_L]

Here you go Romper (thanks for your help).

[romperstomper]

MyTable is the name of your table, not a Range object, so you need:

Please Login or Register  to view this content.

BTW you can call me Rory, rather than Romper.

[D_N_L]

Hi Rory,

Excellent! Thank you very much. It makes perfect sense.

BTW sorry for the lateness of my reply. I never received the auto-email stating there was a reply!

Thank you very much.

[romperstomper]

No worries - glad to help.