D
Doobage20
I am trying on a VBA form to clear the screen leaving blank variables. The
screen does clear fine. The problem I am running into is that one of the
fields being cleared is the product list selection. After the clear screen,
the product list add the list of products to the existing list so the
products are now displayed twice. Clear the screen again and the product
list is displayed three times. Any ideas on why this is happening.
Private Sub ClearButton1_Click()
Prqty.Text = ""
PrComboBox.Value = "Select a Product"
PrMSRP.Text = ""
Prwholesale.Text = ""
Pronline.Text = ""
End Sub
Doobage
screen does clear fine. The problem I am running into is that one of the
fields being cleared is the product list selection. After the clear screen,
the product list add the list of products to the existing list so the
products are now displayed twice. Clear the screen again and the product
list is displayed three times. Any ideas on why this is happening.
Private Sub ClearButton1_Click()
Prqty.Text = ""
PrComboBox.Value = "Select a Product"
PrMSRP.Text = ""
Prwholesale.Text = ""
Pronline.Text = ""
End Sub
Doobage