Hello! I need some assistance!
Need: Combobox selection causes textbox below it to autofill. For example, using my sample, if someone makes the choice of C6 in the combobox, D6 will autopopulate into the textbox.
Issues: I have two lists in Cells C5:D7. There is lots of other stuff all around these lists so I can't use the entire column range in any formulas/VBA. In the real workbook the list is a dynamic data extraction so the length of the lists changes all the time (longer and shorter). If you look at the code for the combobox rowsource (which I'm sure I 'borrowed' from this site somewhere, you'll see how the list changes length. Maybe that's irrelevant if row # could be used. So that's what I was thinking....to pull by row #.....but I have gotten myself so confused that now I can't think straight. Any suggestions would be GREATLY appreciated! THANKS!
Sample workbook: Test.xlsm
Bookmarks