View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] roachware@hotmail.com is offline
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?