making a combobox's linked cell the active cell

[KeithGrindle]

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.

 

[Ivan F Moala]

On 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.

Range(combobox1.linkedcell).Select