Hi All. I have a VBA form with comboboxes on it which I currently have looking at a range of data to populate it. All works well like that but I want to change it so that it looks at a non-contiguous range.
e.g. will need to look at c5, c23, c31, c40 etc for a "y" and then look in the corresponding cell in col A and populate the combo with that.
Is this possible or am I dreaming. I guess I could use Offset to move so many cols to pick up the name?
Should I create code to pick up the "y's" and then put the name value in a separate table? A bit messy as I have a combo box for each day of the month and there are three separate possibilities for each day that need checking.
The selected value in the combobox is then passed to another worksheet but that is OK.
Any suggestions please?
Thanks
e.g. will need to look at c5, c23, c31, c40 etc for a "y" and then look in the corresponding cell in col A and populate the combo with that.
Is this possible or am I dreaming. I guess I could use Offset to move so many cols to pick up the name?
Should I create code to pick up the "y's" and then put the name value in a separate table? A bit messy as I have a combo box for each day of the month and there are three separate possibilities for each day that need checking.
The selected value in the combobox is then passed to another worksheet but that is OK.
Any suggestions please?
Thanks
