UserForm Search, delete issues

		Microsoft Office Forums > Microsoft Excel > Excel Programming
UserForm Search, delete issues

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-10-2014, 01:28 PM

charlesdh

Windows 7 32bit UserForm Search, delete issues

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM
Search for date and then apply mutliple search criteria in huge dataset	maxtymo	Excel	2	12-01-2013 04:52 AM
Looking for Windows Search app with ability to search by content	gopher_everett	Office	1	02-28-2013 09:23 PM
Search for text then delete line	konopca	Word VBA	2	06-07-2012 02:44 AM
Backspace & Delete key issues	marty69	Word	0	08-22-2010 08:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.