Hi.
I've created a userform in Excel, and everything works fine except this..
I've used the following code to make sure that when the macro button for submitting data entered is pressed, data is not submitted without one of the cells (part number) being entered...
'check for a part number
If Trim(Me.txtQty.Value) = "" Then
Me.txtPart.SetFocus
MsgBox "Please enter a part number"
Exit Sub
End If
However, I've used the multipage tool to make the userform two pages. This button is at the bottom of page 2, but the data it refers to is on the top of page 1, and now the button won't work (I get an error message telling me to debug). Any ideas please?
I've created a userform in Excel, and everything works fine except this..
I've used the following code to make sure that when the macro button for submitting data entered is pressed, data is not submitted without one of the cells (part number) being entered...
'check for a part number
If Trim(Me.txtQty.Value) = "" Then
Me.txtPart.SetFocus
MsgBox "Please enter a part number"
Exit Sub
End If
However, I've used the multipage tool to make the userform two pages. This button is at the bottom of page 2, but the data it refers to is on the top of page 1, and now the button won't work (I get an error message telling me to debug). Any ideas please?