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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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....
>
>
>