Hi everyone.
I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).
Can i do this all with a macro?
Thanks
I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).
Can i do this all with a macro?
Thanks