Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Font from this code. Possible ?
Private Sub ComboBox6_DropButtonClick()
Application.ScreenUpdating = False 'Place the References in here for the Roll Numbers and Lengths Dim lastcell As Long Dim myrow As Long lastcell = workSheets("InspectionData").Cells(Rows.Count, "A").End(xlUp).Row With ActiveWorkbook.workSheets("InspectionData") For myrow = 2 To lastcell If .Cells(myrow, 1) < "" Then If .Cells(myrow, 1).Offset(-1, 2).Text = ComboBox28.Text And ..Cells(myrow, 1).Offset(-1, 6).Text = ComboBox1.Text And .Cells(myrow, 1).Offset(0, 0).Value = ComboBox5.Text And IsNumeric(Trim(Mid(.Cells(myrow, 1), 2))) = True Then For i = 2 To 22 If Cells(myrow, 3).Offset(i, 0).Font.Strikethrough = False And Cells(myrow, 3).Offset(i, 0).Value < "" Then ComboBox6.AddItem Cells(myrow, 3).Offset(i, 0) End If Next i End If End If Next End With Application.ScreenUpdating = True End Sub My goal is to have what ever value that is selected in the above code(Combobox6.Value), then the sheet("InspectionData").Value where the value came from to be changed to .Strikethrough Thsi way i can remove it from the list once it had been chosen. Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify code | Excel Discussion (Misc queries) | |||
Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
Modify code in UDF | Excel Programming | |||
Help me modify this VBA code please: | Excel Programming | |||
How to modify VBA code for Add-in? | Excel Programming |