Thread: Userform getting data from Excel table

Hello, everyone,

I've got a problem I seem to be unable to solve by myself.

I've found here a thead with a similar issue, here it is:
http://www.excelforum.com/excel-prog...-criteria.html

I've got exactly the same, but the only difference is that I have my userform in a Word document. My userform has a combobox, and textboxes that should return the values from Excel table depending on the user's selection in the combobox.
I tried to copy the code to my word document, and the problem appears with rng.Find and cl.Offset, and it seems to me that it is because Word treats these variables as word ranges, but not excel ranges. But how should I make this difference when declaring my variables as Range?

I'll be really grateful for any help.

Hello Freaky_zoid,

You are right. The ambiguous object name Range is a problem. To correct it, qualify your object reference in the Dim statement with the Parent object's name. In this case, Excel.

Code:

   Dim xlRng As Excel.Range

Leith,
thank you so much, it works!