Error using Application.Calculation with a UserForm

[Iain Lewis]

Has anyone come across problems using Application.Calculation with a UserForm ?

If I use a UserForm to update data in an XL file I get the following error message when I try & use Application.Calculation any where else

Method 'Calculation' of object '_Application' failed

[Ivan F Moala]

On 2002-05-22 02:27, Iain Lewis wrote:
Has anyone come across problems using Application.Calculation with a UserForm ?

If I use a UserForm to update data in an XL file I get the following error message when I try & use Application.Calculation any where else

Method 'Calculation' of object '_Application' failed

Hi Iain
What version of Excel are you using ?
If excel 97 then try setting your commandbutton
property [TakeFocus*******] to False ?
This is a known problem for ActiveX control
Buttons on Worksheets (xl97), I'm not sure about Userforms ??

I couldn't simulate it in Xl2000.


_________________
Kind Regards,
Ivan F Moala From the City of Sails


[ This Message was edited by: Ivan F Moala on 2002-05-22 04:31 ]

[Iain Lewis]

Yep, I'm on XL 97.

I've tried setting the TakeFocus******* property but still get the error message.

Any other ideas ?

[Ivan F Moala]

On 2002-05-22 08:46, Iain Lewis wrote:
Yep, I'm on XL 97.

I've tried setting the TakeFocus******* property but still get the error message.

Any other ideas ?

Iain, how about the button that lauches the
userform ?? have you set this to False in it's [TakeFocus*******] property ??