Microsoft Office Forums - View Single Post - [Solved] UserForm Search, delete issues

Thread: [Solved] UserForm Search, delete issues

View Single Post

Old

05-10-2014, 01:28 PM

charlesdh

charlesdh is offline

charlesdh uses Windows 7 32bit

Windows 7 32bit charlesdh uses Office 2010 32bit

charlesdh uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

charlesdh is on a distinguished road

Default

Hi,

This bit of code will clear the userform and leave the date inplace.

Code:

Private Sub CommandButton2_Click()
With UserForm1
    .inmate.Text = ""
    .adc.Text = ""
    .race.Text = ""
    .dorm.Text = ""
    .house.Text = ""
    .kitchen.Text = ""
    .job.Text = ""
    .preference.Text = ""
End With
End Sub

Hope this helps in part of your request.

Reply With Quote