• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Disable Start Time Button

N323100

New Member
I want the Start Time to be disable if the user already click on it. I added a Combobox4 but if the user change the details on combobx4 for example from completed to Pending, the Start Time button shows Enabled again. please see file.
 

Attachments

  • RFP ART v1.0.xlsm
    251.4 KB · Views: 11
Your ComboBox4_Change calls CHECK_INPUTRFP which starts with
Me.CommandButton5.Enabled = False
and second to last line is
Me.CommandButton5.Enabled = True
 
N323100
Do next change ... InitialPrepV2 ...
Code:
Private Sub ComboBox4_Change()
    CHECK_INPUTRFP
    If Me.ComboBox4.Value = "Completed" Then
        Me.Frame1.Enabled = True
        Me.Frame1.SetFocus
    End If
    If Me.ComboBox4.Value = "Pending - Team Meeting" Or _
        Me.ComboBox4.Value = "Pending - 1st Break" Or _
        Me.ComboBox4.Value = "Pending - Lunch Break" Or _
        Me.ComboBox4.Value = "Pending - 2nd Break" Or _
        Me.ComboBox4.Value = "Pending - Coaching" Then
        Me.Frame1.Enabled = False
        INIT_FORM1
    End If
    CommandButton5.Enabled = False
End Sub
... after that Your 'Start Button' will work as You wrote.
 
Back
Top