Range(combobox1.linkedcell).SelectOn 2002-05-11 14:16, KeithGrindle wrote:
I have several combo box's and on the click event I want to make it's linked cell the active cell.
If I set the activecell = combobox1.linkedcell then whatever cell happens to be active at that time gets the cell address as it's value.
I would like to be able to write a procedure so that no matter what combo box I click in it automatically makes the respective linked cell the active cell. I do not want to have to write out the code for each combobox.
Thanks in advance.