ExcelBanter - Closing Forms

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Closing Forms (https://www.excelbanter.com/excel-programming/355466-closing-forms.html)

Justin Philips

Closing Forms

Is the only way to close a form UserForm1.Hide? I need to actually
close the form because on initialize certain things are set to
default...so everytime a user calls UserForm1 i need it to be
reopened...not just unhid..

-Justin

RB Smissaert

Closing Forms

Unload UserForm1

RBS

"Justin Philips" wrote in message
ups.com...
Is the only way to close a form UserForm1.Hide? I need to actually
close the form because on initialize certain things are set to
default...so everytime a user calls UserForm1 i need it to be
reopened...not just unhid..

-Justin

Justin Philips

Closing Forms

so simple...yet so cool

N10

Closing Forms

Additional icing

Unload UserForm1

Set UserForm1 = Nothing

n10

"Justin Philips" wrote in message
oups.com...
so simple...yet so cool

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