Use combobox for universal purpose
Pat,
Is this what you mean?
Range("G10").Value = Activesheet.Combobox1.List(Range("A1").Value-1)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Pat" wrote in message
...
Oh. Sorry I should have clarified what will be contained in the
FillListRange.
The FillListRange will contain data from another part of the workbook and
will have at least 2 columns of data contained in it. It will be one of
these two columns of data where an item of information will be selected
and
thereby be displayed in say A51.
All A1 will be used for is to enter the row number of the sheet and then
when the combobox is clicked the combobox will look at A1 (using code) and
after determining the value in A1 will place the selection from the
combobox
into the corresponding cell.
Pat
"Bob Phillips" wrote in message
...
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
|