Results 1 to 5 of 5

UserForm and CheckBox

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    UserForm and CheckBox

    This is just a example of what I'm trying,I have a userform on my worksheet and two checkboxes. One of the checkbox has to be checked to run another function on the sheet,I can't get the commandbutton in the userform to see the checkboxes.I put a commandbutton on the sheet and it works perfect,not sure why userform does not work, Iposted a exampl workbook to see my problem. Here is my code

    Private Sub CommandButton1_Click()
    If Not (CheckBox1 Or CheckBox2) Then
          MsgBox "You must check the Rough or Finish checkbox "
         End If
    
    End Sub
    Attached Files Attached Files
    Last edited by zplugger; 12-05-2011 at 08:31 PM.

Thread Information

Users Browsing this Thread

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

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