Excel 2004: "End" statement doesn't terminate UserForm

[Edwin Tam]

[Excel 2004]

I posted earlier that, if the "End" statement is included in the "Click"
event of a button on an UserForm, for unknown reasons, the form doesn't
(always) dismiss when the button is clicked.

In order to ensure the form successfully dismisses, you need to add a line:
Me.Hide
before the End statement.

I referred to other VB literature, including VB 2003.NET Unleashed for the
"standard" coding of forms, I confirmed that the "End" statement SHOULD
always be reasonably be expected to be able to dismiss a form.

I hate this. Microsoft please fix this fundamental bug!!

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[J Laroche]

Edwin Tam wrote on 2005/03/22 03:15:

[Excel 2004]

I posted earlier that, if the "End" statement is included in the "Click"
event of a button on an UserForm, for unknown reasons, the form doesn't
(always) dismiss when the button is clicked.

In order to ensure the form successfully dismisses, you need to add a line:
Me.Hide
before the End statement.

I referred to other VB literature, including VB 2003.NET Unleashed for the
"standard" coding of forms, I confirmed that the "End" statement SHOULD
always be reasonably be expected to be able to dismiss a form.

I hate this. Microsoft please fix this fundamental bug!!

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

I always terminate my user form use with:
Me.Hide
Unload Me

I think that's the only surefire way to dismiss it.

JL
Mac OS X 10.3.8, Office v.X 10.1.6

 

[Edwin Tam]

"END", in the language of Visual Basic, no matter what, SHOULD be able to
dismiss an UserForm/Form.

We are lucky that we found a work around "trick" which is simple enough to
solve this BUG easily. But it won't change the problem -- this is a
fundamental bug in the Excel 2004 VBA.

It is not reasonable to expect a normal VBA literate user to realize this
solution by default. If the MS MacBU really want to pull Windows users to Mac
Office, they must improve the realibility and stability of Excel VBA. The
"END" statement is just one of the examples.

Regards,
Edwin Tam

I always terminate my user form use with:
Me.Hide
Unload Me

I think that's the only surefire way to dismiss it.

JL
Mac OS X 10.3.8, Office v.X 10.1.6

Edwin Tam wrote on 2005/03/22 03:15:

[Excel 2004]

I posted earlier that, if the "End" statement is included in the "Click"
event of a button on an UserForm, for unknown reasons, the form doesn't
(always) dismiss when the button is clicked.

In order to ensure the form successfully dismisses, you need to add a line:
Me.Hide
before the End statement.

I referred to other VB literature, including VB 2003.NET Unleashed for the
"standard" coding of forms, I confirmed that the "End" statement SHOULD
always be reasonably be expected to be able to dismiss a form.

I hate this. Microsoft please fix this fundamental bug!!

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com