![]() |
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.... |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com