LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Clearing Form Values the easy Way???

Herro!! Okay, I have been clearing forms upon exiting them by
individual fields, and it is a pain in my ass. Example:

Sub ClearRWts()
RWts.Hide
RWts.textbox1.Clear
RWts.Caption.Clear
RWts.Pain.Clear
RWts.InMy.Clear
RWts.colon.Clear
RWts.textbox2.Clear
End Sub

So...let us say that the above code includes like 18 lines to clear an
entire form so that the next time it will be fresh and clean like a new
tissue from the kleenex box...Please tell me there is an easy way to do
this. I have tried the following, but they did not work:

RWts.Clear

RWts.Close

RWts.JustDeleteEverythingDammit

RWts.Values.Clear


Apparently, these are not allowed as they either only exist in my head,
or are not correct statements or syntax.

Oh dear stranger reading this, will you not help this poor soul who
must endure countless hours of useless line-by-line code entry?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing the Values in a Drop - Down List Sagu Excel Discussion (Misc queries) 4 March 31st 06 03:32 AM
Clearing Form PEno1 Excel Programming 2 December 12th 04 09:18 PM
Custom form on opening - I think it's an easy one for the experts David Excel Programming 4 June 4th 04 06:32 AM
vba clearing out values stored in array chick-racer[_44_] Excel Programming 2 December 1st 03 09:05 PM
Clearing list from all form commandboxes josh ashcraft Excel Programming 2 August 19th 03 12:58 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"