When I open the Userform & tab through controls, this code is not having any effect?
Thanks in advancePrivate Sub cmbMonth_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) If IsEmpty(cmbMonth.Value) Then cmbMonth.BackColor = rgbPink Cancel = True End If End Sub Private Sub LstCustomer_AfterUpdate() If IsEmpty(LstCustomer.Value) Then lblCustomer.ForeColor = vbRed Cancel = True End If End Sub
Bookmarks