I created a userform which has several text boxes and 3 buttons.
The button I'm concerned with is the Cancel button, which I would like to "Cancel" the operation. Specifically, if any data was entered, I do not want it written to the worksheet.
What I would like to accomplish is to identify that the Cancel button (specifically) has been clicked; or how to determine/define which button, has been clicked.
The With statement looks like this
The button I'm concerned with is the Cancel button, which I would like to "Cancel" the operation. Specifically, if any data was entered, I do not want it written to the worksheet.
What I would like to accomplish is to identify that the Cancel button (specifically) has been clicked; or how to determine/define which button, has been clicked.
The With statement looks like this
Code:
With frmEstimateRecord
.lblEstimateNum.Caption = "Estimate Number: " & newEstimate.number
.txtDate.Value = newEstimate.date
.Show
newEstimate.date = .txtDate.Value
newEstimate.customer = .txtCustomer.Value
newEstimate.jobname = .txtJob.Value
newEstimate.description = .txtDescription.Value
End With