Hi all,
I would like to refresh my userform but keep the label data.
The label data is pulled from the sheet;
When i use unload me and use Userform1.shows all the data is gone.
I would like that it keeps the data in the labels.
Is that possible?
I would like to refresh my userform but keep the label data.
The label data is pulled from the sheet;
VBA Code:
With Medicine_Returns
.lblProductcodeR = Cells(Target.Row, "B")
.lblBatchnumberR = Cells(Target.Row, "A")
.lblDepartmentR = "Medicine"
.lblReviewerR.Caption = Cells(Target.Row, "F")
.txtDateOfObservation = Format(Now(), "dd/mmm/yy")
.Show
End With
When i use unload me and use Userform1.shows all the data is gone.
I would like that it keeps the data in the labels.
Is that possible?