Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Verify Userform complete before close
I have a userform with several textboxes for data input. Before the form is
closed I would like to check that all textboxes contain data. If one or more is blank, I would like to cancel the close and alert the user. I suspect I need a statement in the QueryClose event and I was trying to use something like this: For Each Textbox in Userform (Statements) Next This doesn't work "Object doesn't support this property or method". I suppose I'm having difficulty understanding what a collection is. Whatever my lack of understanding, any help to check a userform for blank textboxes before closing the form? Thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cannot complete this task with available resources. choose less data or close other applications | Excel Programming | |||
Excel can not complete this task with available resources. Choose less data or close other applications. | Excel Discussion (Misc queries) | |||
close UserForm | Excel Programming | |||
Copying Userform with Controls OR complete application. | Excel Programming | |||
witing for ms word to complete tasks the close | Excel Programming |