making a combobox's linked cell the active cell

KeithGrindle · May 11th, 2002, 03:16 PM

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 · May 11th, 2002, 03:30 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 03:16 PM	#1
KeithGrindle New Member Join Date: Apr 2002 Posts: 5	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.