textbox empty - show message box

[cnu nagula]

Dear Friends,

i have userform with textboxes and commandbox.

i have 8 texboxes and 1 combobox.

i need a code to watch all textboxes are not empty, when i click combobox1. if any textbox is empty, a message is to popup, " your data in textbox? is not entered" i mean in a particular textbox

please help in this regards

 

[Norie]

Something like this perhaps.

Private Sub CommandButton1_ Click()
Dim ctl As MSForms.Control

      For Each ctl In Me.Controls

         If TypeName(ctl) ="TextBox" Then
              If ctl.Value ="" Then
                    MsgBox ctl.Value & " empty, please enter something"
                     ctl.SetFocus
                      Exit Sub
              End If
          End If
      Next ctl
End Sub

 

[cnu nagula]

Thank you, it is working.

i need a audio warning beep or any other audio

 

[Norie]

There is the simple Beep I suppose.

Though I would have thought that would be more appropriate when the user exits a textbox they've left empty.

That could be done using the Exit event of each textbox.

If you only have a few textboxes you can just duplicate the same code for each one, changing names appropriately.

 

[cnu nagula]

i don't know the exit event for combobox or to textbox, i am not even learner