Hi,
I have created a user form, which has various combo box's on which have been linked to an Excel Worksheet. What i want to do is select a item from a combobox (This would correspond to Cell A1 on my workseet) In a separate box i would like it to return the value which is located, in the same worksheet and row, but in a different column (for Example A7). Whats the Best way of Doing this????
Any Help would be most appreciated
Manny
I have created a user form, which has various combo box's on which have been linked to an Excel Worksheet. What i want to do is select a item from a combobox (This would correspond to Cell A1 on my workseet) In a separate box i would like it to return the value which is located, in the same worksheet and row, but in a different column (for Example A7). Whats the Best way of Doing this????
Any Help would be most appreciated
Manny