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

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

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

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

Not sure what to do with this?

Pat

"Bob Phillips" wrote in message
...
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

You might get a start with this. I used one ComboBox names "cb" Left is
set to zero, and setup 18 Rows to have a height that worked well with
my combobox size (17.25). The combobox will follow the ActiveCell.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If (ActiveWindow.ActiveCell.Column = 1) And
(ActiveWindow.ActiveCell.Row <= 18) Then 'Column A & <= Row 18
cb.LinkedCell = ActiveWindow.ActiveCell.Address(rowabsolute =
False, columnabsolute = False)
cb.Top = (ActiveWindow.ActiveCell.Row *
ActiveWindow.ActiveCell.Height) - ActiveWindow.ActiveCell.Height
End If
End Sub



Good Luck.


---
Message posted from http://www.ExcelForum.com/

Can anyone tell me why the combobox I have been using quite successfull
for some time nolonger align itself to the target cell. All th
property settings are correct. When a cell in the range is selected th
combobox appears several cell above. It does not matter how many time
the settings are changed it still appears exactly the same number o
cell above the target cell.

I know this is an old thread, hopefully someone with the knowledge wil
be able to help.:)

Regards
Pa

--
Message posted from http://www.ExcelForum.com