Combobox value to be set as Target for referencing from. How ?
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.... |
Setting Target or address????
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.... |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com