I've got a combo box which is populated from column A from sheet 1. I am linking each item in that combobox to a Macro. I don't want to hardcode it like this....
If ComboBox1.Text = "Early Years" Then Call EarlyYears
Is there a way I can link it from the cell it came from.....so for example "Early Years" came from A8. Incase that title changes I want the coding to be flexible and accommodate that change.
Can anyone help?
Bookmarks