Data Form and Macro!

Rutter · Apr 24th, 2002, 08:15 AM

Hey there, hope u guys/girls can help me!
Im having a problem, Im trying to add a macro to open the data form but I keep getting run time error '1004', so I click debug, and it all looks ok, can anyone help me?
My VB code looks like this
Sub adddel()
'
' adddel Macro
' Add and Delete Stock from Shop_Stock
'

'
ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
End Sub

Thanx
Rutter

[ This Message was edited by: Rutter on 2002-04-24 07:20 ]

Steve Hartman · Apr 24th, 2002, 09:48 AM

Quote:

ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
End Sub

I think it should be:
NameOfYourDataForm.Show

Rutter · Apr 24th, 2002, 10:08 AM

no I want to open the data form avalible in excel, through the options menus Data>Form

Anmore ideas mate?

act13 · May 8th, 2002, 02:18 PM

it's a bug, check out
http://support.microsoft.com/default...;en-us;Q213835
for a workaround

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

Apr 24th, 2002, 08:15 AM	#1
Rutter New Member Join Date: Apr 2002 Posts: 6	Hey there, hope u guys/girls can help me! Im having a problem, Im trying to add a macro to open the data form but I keep getting run time error '1004', so I click debug, and it all looks ok, can anyone help me? My VB code looks like this Sub adddel() ' ' adddel Macro ' Add and Delete Stock from Shop_Stock ' ' ActiveSheet.ShowDataForm (It tell me the problem lies here!!) End Sub Thanx Rutter [ This Message was edited by: Rutter on 2002-04-24 07:20 ]

Apr 24th, 2002, 10:08 AM	#3
Rutter New Member Join Date: Apr 2002 Posts: 6	no I want to open the data form avalible in excel, through the options menus Data>Form Anmore ideas mate?

May 8th, 2002, 02:18 PM	#4
act13 New Member Join Date: May 2002 Location: NYC Posts: 41	it's a bug, check out http://support.microsoft.com/default...;en-us;Q213835 for a workaround