Use combobox for universal purpose
I want to use just one combobox to change any cell in a single column. What
I purpose is to have the Linked Cell, say A1 used to identify the row number
of the cell to be have the focus. For eg. lets say I type 51 into A1 (51
representing the row number), when the combobox is activated this fires
code which tells the combobox that A1 has the row 51 column A as the current
linked cell.
What that means is that that one combobox will function for any number of
cell in a single column.
What do you think, is this possible?
regards
Pat
|