Rlb53
10-11-2012, 03:44 AM
I desire to keep a command button hidden until an absolute number of comboboxes and textboxes have been filled with data.
After hours of failing with this... I opted to allow the command button to be visible, but I would like to keep it from being operable until all data has been entered, but provide an error message if it is selected prior.
I have been attempting to nest the "IF" Command, but it is not working with the syntax I have prepared. I am not getting an error message, but it is giving me a false statement with my testing.
The Nesting consists of 14 conditions.
If Not Sheets("sheet2").BOLsheetcustomerlist = "" & _
Not Sheets("sheet2").BOLSheetCity = "" & _
not sheets("Sheet2").BOLSheetProduct="" Then
MsgBox "All Fields Have Been Entered.
Else
MsgBox "All Fields Have Not Been Entered.
End If
I've also tried to nest the command as:
If Sheets("sheet2").BOLsheetcustomerlist = "" or _
Sheets("sheet2").BOLSheetCity = "" Then
MsgBox "All Fields Have NotBeen Entered.
Else
MsgBox "All Fields Not Been Entered.
End If
Could you assist ? The Goal is to have all data entered prior to Save.
Thank you !
After hours of failing with this... I opted to allow the command button to be visible, but I would like to keep it from being operable until all data has been entered, but provide an error message if it is selected prior.
I have been attempting to nest the "IF" Command, but it is not working with the syntax I have prepared. I am not getting an error message, but it is giving me a false statement with my testing.
The Nesting consists of 14 conditions.
If Not Sheets("sheet2").BOLsheetcustomerlist = "" & _
Not Sheets("sheet2").BOLSheetCity = "" & _
not sheets("Sheet2").BOLSheetProduct="" Then
MsgBox "All Fields Have Been Entered.
Else
MsgBox "All Fields Have Not Been Entered.
End If
I've also tried to nest the command as:
If Sheets("sheet2").BOLsheetcustomerlist = "" or _
Sheets("sheet2").BOLSheetCity = "" Then
MsgBox "All Fields Have NotBeen Entered.
Else
MsgBox "All Fields Not Been Entered.
End If
Could you assist ? The Goal is to have all data entered prior to Save.
Thank you !