Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing the Values in a Drop - Down List | Excel Discussion (Misc queries) | |||
Clearing Form | Excel Programming | |||
Custom form on opening - I think it's an easy one for the experts | Excel Programming | |||
vba clearing out values stored in array | Excel Programming | |||
Clearing list from all form commandboxes | Excel Programming |