Results 1 to 11 of 11

how to skip a boolean checkbox

Threaded View

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    how to skip a boolean checkbox

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to skip user form clear to skip particular text box
    By narsing18 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2017, 08:44 AM
  2. [SOLVED] Exit Workbook_BeforeClose(Cancel As Boolean) if a public boolean = true
    By meabrams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2016, 06:10 AM
  3. Select All Checkboxes Checkbox That Also Calls Checkbox Macros
    By Intervigilium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2015, 06:41 PM
  4. # of blank labels to skip
    By jdlc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2014, 03:36 PM
  5. Protect the sheet but the form checkbox still can be change and sort by checkbox
    By carolyn1221 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 01:08 PM
  6. Formula for avg skip, max skip, longest out
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2010, 04:56 PM
  7. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) problem
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2009, 07:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1