i have this workbook that cycle's through a sheet (actually two) and i want to mark a particular shortcut as read. this is working but when i press the next or previous button (to cycle), it stops and doesn't jump over a true checkbox. will upload the workbook for you to see.
here is what i think needs to be configured:
Private Sub CheckBox1_Click()
indexVBA = ThisWorkbook.Sheets("Formulas").Range("IndexVBA")
indexExcel = ThisWorkbook.Sheets("Formulas").Range("IndexExcel")
'test for listbox being "VBA"
If ListBox1.Value = "VBA" Then
'test for checkbox being "True"
If CheckBox1.Value = True Then
chkbxV(indexVBA) = True
If indexVBA < 99 Then
indexVBA = indexVBA + 1
If chkbxV(indexVBA) = True Then
indexVBA = indexVBA + 1
End If
Else
indexVBA = indexVBA - 1
End If
Sheets("Formulas").Range("A2") = indexVBA
ListBox1_Click
CheckBox1.Value = False
Else
chkbxV(itemVBA) = False
End If
Debug.Print "chkbxV(" & itemVBA & ") is " & chkbxV(itemVBA)
Else
If ListBox1.Value = "Excel" Then
'do excel here
End If
End Sub
i think that this is just a mess and will probably have to be completely rewritten.
also my next and previous seems to be working ok, but not sure if there needs to be coded added to it.
Bookmarks