ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,235
- Office Version
- 2007
- Platform
- Windows
Hi,
Upon clicking yes on msgbox i would then like TextBox to be empty
I have the following in use but Textbox1 doesnt clear its value
Upon clicking yes on msgbox i would then like TextBox to be empty
I have the following in use but Textbox1 doesnt clear its value
Rich (BB code):
If Not c Is Nothing Then
If MsgBox("ARE YOU SURE YOU WISH TO DELETE CUSTOMER " & ListBox1.Text & "?", vbYesNo + vbInformation, "DELETE CUSTOMER FROM DATABASE") = vbYes Then
Rows(c.Row).EntireRow.Delete
MsgBox "THE CUSTOMER " & Me.ListBox1.Value & " HAS NOW BEEN DELETED", vbInformation, "CUSTOMER DELETED MESSAGE"
End If
MsgBox "DELETE ANOTHER CUSTOMER ?", vbYesNo + vbQuestion
If answer = vbYes Then
TextBox1.Value = ""
End If
Else
MsgBox "THE CUSTOMER " & Me.ListBox1.Value & " WAS NOT DELETED", vbInformation, "CUSTOMER WAS NOT DELETED MEAASGE"
Range("A6").Select
End If
Set c = Nothing
End Sub