KeithGrindle
New Member
- Joined
- Apr 11, 2002
- Messages
- 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.
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.