Use combobox for universal purpose
Pat,
It is possible, but what is the purpose of the combobox if you will just
display 1 cell. Why not just goto row 51 when 51 is entered in A1?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Pat" wrote in message
...
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
|