Hiding forms with a timed event

Skippy · Apr 10th, 2002, 10:54 AM

I am using the following to hide a userform after opening a workbook. It worked fine the first few times. Then I start getting an error message that the macro "KillTheForm" cannot be found. Any idea what the problem is?

Application.OnTime Now + TimeValue("00:00:02"), "KillTheForm"

Sub KillTheForm()
frmMenu.Hide
Call ListView
frmMarginalCosts.Show
End Sub

Tom Schreiner · Apr 10th, 2002, 10:58 AM

Hi
Make sure that Sub KillTheForm() is in a Standard Module and not in a sheet, workbook, or userform Class module...
Tom

Skippy · Apr 10th, 2002, 11:02 AM

TsTom

KillTheForm is in a module. I had been working OK for a while then all of a sudden I'm now getting the error message.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 10:54 AM	#1
Skippy Board Regular Join Date: Mar 2002 Location: Montreal, Quebec Posts: 194	I am using the following to hide a userform after opening a workbook. It worked fine the first few times. Then I start getting an error message that the macro "KillTheForm" cannot be found. Any idea what the problem is? Application.OnTime Now + TimeValue("00:00:02"), "KillTheForm" Sub KillTheForm() frmMenu.Hide Call ListView frmMarginalCosts.Show End Sub

Apr 10th, 2002, 10:58 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Make sure that Sub KillTheForm() is in a Standard Module and not in a sheet, workbook, or userform Class module... Tom

Apr 10th, 2002, 11:02 AM	#3
Skippy Board Regular Join Date: Mar 2002 Location: Montreal, Quebec Posts: 194	TsTom KillTheForm is in a module. I had been working OK for a while then all of a sudden I'm now getting the error message.