Excel User forms 1

[memberlogin]

is it possible to turn off the close fuction on a user forms as the properties to a user form do not include a choice

 

[Rolliee]

make the specific field a 'required' value and it will not close without something in that field.

Rollie@bwsys.net

 

[memberlogin]

this form has been created in Excel and not in Access, what I want to do is deactivate the close button.
is there anyone else out there with any good Ideas?

 

[combo]

You can use queryclose event: UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) where CloseMode describes how the user tries to close the form (vbFormControlMenu=0 - via x button) and Cancel=True cancels closing.
Another option - API code to hide system buttons and leave empty form's bar (see one of MVP's formfun.xls file mentioned in vba forum or in internet)

combo

 

[combo]

Just to complete my previous info - check Stephen Bullen's
Excel Pages with FormFun.zip at

http://www.bmsltd.co.uk/Excel/Default.htm

combo

 

[memberlogin]

Thanks Combo Have a Star!