ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,232
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a TextBox on my worksheet which i would like to clear when workbook is closed.
I have this below but will not clear it.
I have a TextBox on my worksheet which i would like to clear when workbook is closed.
I have this below but will not clear it.
Rich (BB code):
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.EnableEvents = False
Sheets("HONDA SHEET").Range("A13,A17").ClearContents
Sheets("HONDA LIST").TextBox1.Value = ""
Application.EnableEvents = True
End Sub