With the following section of code, i currently have a combobox value placed
in cell O4.

With ActiveWorkbook.workSheets("Inspections")
..Select
Range("O4").Value = ComboBox1.Value
End With

The combobox value is taken from sheet4 and placed in O4 in sheet2 for
viewing when required.

This value from sheet4, is ALWAYS in column A, but can be in any row.

I want to place many other values from sheet4 into sheet2 also, but need to
reference these other values ACCORDING to where the value in the combobox
value is.
IE.

I want to use some thing like, if combobox1.value was in seet4.range("A1")
then :

Combobox1.value = sheet4.target cell

sheet2.range("A5").value = targetcell.offset(0,4).value ' I can then place
the other values from sheet4 into sheet2 by where those values are related
to the location of the combobox value(Target).


To hopefully explain clearer.
EG.

sheet4:

A1 = 500
A5 = ABC
B3 = Yellow
C2 = 1000


When the combobox value is selected(sheet4.column A):

Sheet2:
Target = 500
A5 = target.offset(0,4)
B3 = target.offset(1,2)
C2 = target.offset(2,1)
etc....

All these values that are brought in from sheet4, are NOT in any specific
ROW.
Therefore i need to refernce them by WHERE the combobox value WAS.

Can anyone help me get started on this ?

Corey....

Any Takers???

How do i set the combobox value chosen to be a target or address to locate
other values from?

COrey....
"Corey" wrote in message
...
With the following section of code, i currently have a combobox value
placed in cell O4.

With ActiveWorkbook.workSheets("Inspections")
.Select
Range("O4").Value = ComboBox1.Value
End With

The combobox value is taken from sheet4 and placed in O4 in sheet2 for
viewing when required.

This value from sheet4, is ALWAYS in column A, but can be in any row.

I want to place many other values from sheet4 into sheet2 also, but need
to reference these other values ACCORDING to where the value in the
combobox value is.
IE.

I want to use some thing like, if combobox1.value was in seet4.range("A1")
then :

Combobox1.value = sheet4.target cell

sheet2.range("A5").value = targetcell.offset(0,4).value ' I can then place
the other values from sheet4 into sheet2 by where those values are related
to the location of the combobox value(Target).


To hopefully explain clearer.
EG.

sheet4:

A1 = 500
A5 = ABC
B3 = Yellow
C2 = 1000


When the combobox value is selected(sheet4.column A):

Sheet2:
Target = 500
A5 = target.offset(0,4)
B3 = target.offset(1,2)
C2 = target.offset(2,1)
etc....

All these values that are brought in from sheet4, are NOT in any specific
ROW.
Therefore i need to refernce them by WHERE the combobox value WAS.

Can anyone help me get started on this ?

Corey....