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