Sorry Tom but that's not exaclty what I mean.

I don't no if it's possible.but the check must be in d
Commandbutton.

Something like

Code
-------------------

If Counter=0 Then
MsgBox "All data has been filled"
Unload Me
menu.show
Else

//rest of code

End Sub

-------------------


--
Message posted from http://www.ExcelForum.com