Results 1 to 4 of 4

Userform - checkbox

Threaded View

Lukael Userform - checkbox 03-11-2014, 06:15 AM
Sc0tt1e Re: Userform - checkbox 03-11-2014, 06:23 AM
Lukael Re: Userform - checkbox 03-11-2014, 06:38 AM
6StringJazzer Re: Userform - checkbox 03-11-2014, 01:49 PM
  1. #1
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Userform - checkbox

    Hello,

    I have userfom and I need to tick checkboxes If two cell values in range have string values. I have monthly work schedule for shifts, and checkboxes must be ticked If job is entered.

    So, If in E3 is "OP1", and in E4 is "06:18:00", than I want in Userform to be ticked "OP1- daily shift" checkbox.

    Problem is that I have this for each days in month, in a range from row 3 to 318, for both cells (E3 and E4) in step 4. Right now I'm struggling with Select case statements, but nothing works

    Have tried also to select cells and then perform If statements, but still nothing. Did I even select cells correct ? something like this :
    dim lngrow as Long
    dim lngrow2 as Long
    
     For lngRow = 5 To .Cells(.Rows.Count, 1).End(xlUp).Row Step 4
    
    next
    
    For lngrow2 = 6 to .Cells(.Rows.Count, 1).End(xlUp).Row Step 4
    next
    I have attached Userform, you'll see what I have and what do I need to be changed. Previous checkboxes can be deleted, don't need them anymore. Thanks for any help !!!

    Regards
    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. USERFORM with a CHECKBOX USED IN different COLUMNS
    By brika in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2014, 09:01 AM
  2. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  3. UserForm and CheckBox
    By zplugger in forum Excel General
    Replies: 4
    Last Post: 12-05-2011, 10:39 AM
  4. Can't get checkbox to go true from another userform
    By mhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2009, 12:10 PM
  5. Userform Checkbox
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 05:15 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