I attached a small jpg of a grid...
I figured out how to use the ADDRESS function coupled with MATCH to have the cell address returned to me... I can answer the question, what is the address of the cell whose intersection is feb & red. (using the "=" in another cell on the sheet, not in a userform)
what i want to do is create a userform in which the user will use 2 different combo boxes to select which month and which color, and then the OK comman will write the textbox data to the appropriate cell
any help is much appreciated !
thanks!
-rob
Bookmarks