i have a worksheet with names listed in column A and dates listed on row 1.
what i need to do is to use two comboboxes/listboxes (don’t know which is better for this situation!); the first one the user selects the name and the second selects the date.
my question: is there any way, when the user selects a name, that the combo/list box finds that particular name and takes notes of the row in which it resides (as variable “a”) and similarly a column for the date (as variable “b”) as integers. [ie. row 3 column C: a=3, b=3]??
thanks!