C
Corey
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....
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....