Hi, Everyone.
I am trying to conduct a lookup to range in a closed workbook, based on the value in a combo box, in order to fill a value in a text box on a userform.
The combobox lists are filled by accessing a closed workbook. I found a solution to achieve that, but not how to conduct a lookup.
The following code snippet crashes out with the error "Object doesn't support this property or method."
Can anyone please advise on the correct approach to do a lookup to another workbook from within a Userform?HTML Code:
Any help very appreciated.
Thanks.
jagman
Bookmarks