Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify code to reference from a Matching value in Combobox1
Can anyone help me modify the below code ?
I want to have the highlighted line to refer to a matching value in sheet6 column A with the value selected in combobox1. Dim i As Long With workSheets(1).Range("N1") ' <============== Want this range to be the value that was selected from the combobox. This value was from sheet6(A:A). .Offset(i, 0).Value = workSheets(i).Name .Offset(i, 1).Value = workSheets(i).Range("B3").Value .Offset(i, 2).Value = workSheets(i).Range("Z48").Value .Offset(i, 3).Value = workSheets(i).Range("V3").Value .Offset(i, 4).Value = workSheets(i).Range("J59").Value End With I want to be able to use this Cell as a reference from for OTHER data as the rest of the code seems to do. IE. I can then get the value that is ((Offset(1, 4) for example )) from that combobox value in sheet6 column A. etc.............. Can anyone assist me with starting this? Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify code | Excel Discussion (Misc queries) | |||
Modify Code | Excel Worksheet Functions | |||
ComboBox1 | Excel Discussion (Misc queries) | |||
Modify code in UDF | Excel Programming | |||
Help me modify this VBA code please: | Excel Programming |