Results 1 to 9 of 9

Thread: Userform problem [Message box for missing entry in opt and chk button]

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    Junior Member
    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    Sir
    I'm looking something similar to your previous code
    Code:
    If Not (optAAA.Value) + (optBBB.Value) + (optCCC.Value) Then
        optCCC.SetFocus
        MsgBox "Pls choose product"
        Exit Sub
    End If
    Similar case, but instead of option button I will use checked button

    Code:
    If Not (chkXXX.Value) + (chkYYY.Value) + (chkZZZ.Value) Then
        chkXXX.SetFocus
        MsgBox "Pls choose 2 or 3 brand"
        Exit Sub
    End If
    Last edited by Excel Fox; 05-21-2013 at 08:32 AM. Reason: Quote Removed

Similar Threads

  1. Solve Block If Without End If Problem
    By jffryjsphbyn in forum Excel Help
    Replies: 3
    Last Post: 06-12-2013, 11:06 AM
  2. Replies: 4
    Last Post: 04-05-2013, 12:08 PM
  3. Message Box Pop-Up "yes or no"
    By Ryan_Bernal in forum Excel Help
    Replies: 1
    Last Post: 02-19-2013, 06:20 PM
  4. Display sheet names in a message box
    By pells in forum Excel Help
    Replies: 4
    Last Post: 02-13-2013, 07:33 PM
  5. Message Box Before Saving Document
    By Lucero in forum Excel Help
    Replies: 2
    Last Post: 04-15-2012, 07:09 AM

Posting Permissions

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