DataForm.Show does not work in code
 

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Sub Macro3()
Range("AS1").Select
UpDaTe.Show <========
End Sub


Everytime I type Update, it changes to UpDaTe

??? why is that, I found a code which was named UpDaTe, and deleted it but
it still does that change.



"Toppers" wrote:

If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Update is reserved word so rename your form to "frmUpdate".

If you want, post your workbook to me - - and
I'll look at it offline.

"ufo_pilot" wrote:

Sub Macro3()
Range("AS1").Select
UpDaTe.Show <========
End Sub


Everytime I type Update, it changes to UpDaTe

??? why is that, I found a code which was named UpDaTe, and deleted it but
it still does that change.



"Toppers" wrote:

If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Sub ready()
Range("AS1").CurrentRegion.Name = "Database"
frmDataForm.Show
End Sub

--
Regards,
Tom Ogilvy


"ufo_pilot" wrote in message
...
Sub Macro3()
Range("AS1").Select
UpDaTe.Show <========
End Sub


Everytime I type Update, it changes to UpDaTe

??? why is that, I found a code which was named UpDaTe, and deleted it but
it still does that change.



"Toppers" wrote:

If form name is "Update" (the name in the Properties of the Userform)
then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or
method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I
want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your
worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a
button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

His original question doesn't use a Userform. He is using the built in
dataform.

--
Regards,
Tom Ogilvy

"Toppers" wrote in message
...
If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your
worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button
so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

I obviously need a (the) holiday! Thanks Tom.

"Tom Ogilvy" wrote:

His original question doesn't use a Userform. He is using the built in
dataform.

--
Regards,
Tom Ogilvy

"Toppers" wrote in message
...
If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your
worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button
so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

Hey, Guys
I think your input on this forum is just awsome, I have had so much positive
help from here, that it spurs me on to learn all this macro / VBA stuff
cheers.
Petra ( not from Blue Peter either...)

"Toppers" wrote:

I obviously need a (the) holiday! Thanks Tom.

"Tom Ogilvy" wrote:

His original question doesn't use a Userform. He is using the built in
dataform.

--
Regards,
Tom Ogilvy

"Toppers" wrote in message
...
If form name is "Update" (the name in the Properties of the Userform) then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your
worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button
so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

THIS ONE WORKS!!!!!!
I've played around with it, but for some reason, this one does it.
Thanks for all your help.

Sub ShowForm()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub



"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a button so that a
list can be updated, but the codes below do not seem to work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub

DataForm.Show does not work in code
 

I misread his code and assumed he was trying to use the Data = Form
command. based on his lastest post, that is apparently what he is doing,
but used the wrong command. (which I missed). My answer should have been

Sub ready()
Activesheet.Range("AS1").CurrentRegion.Name = "Database"
ActiveSheet.ShowDataForm
End Sub

--
Regards,
Tom Ogilvy


"Toppers" wrote in message
...
I obviously need a (the) holiday! Thanks Tom.

"Tom Ogilvy" wrote:

His original question doesn't use a Userform. He is using the built in
dataform.

--
Regards,
Tom Ogilvy

"Toppers" wrote in message
...
If form name is "Update" (the name in the Properties of the Userform)
then
use "Update.show". Your code is looking for a form called "frmUpdate".

"ufo_pilot" wrote:

The name on the Form is 'Update'
tried it with the name:

Sub ready()
Range("AS1").Select
frmUpdate.Show
End Sub


here the error is 438 - Object doesn't support this property or
method

Sub Macro3()'
Range("AS1").Select
ActiveSheet.frmUpdateVisible , True
End Sub

???? I'm trying to edit both codes to see which one gives me what I
want
first...
Thanks for your help.


"Toppers" wrote:

Check the Userform name is correct

"ufo_pilot" wrote:

I get a Run Time Erroe 424 "Object required
when the button is clicked.

"Toppers" wrote:

Hi,
How is code started form the button?

Use the Forms toolbar, select a button, place button in your
worksheet and
assign your macro (READY) to it.

Click the button and the form should appear.

HTH

"ufo_pilot" wrote:

Hello all
I am trying to have the Data Form show upon a click of a
button
so that a
list can be updated, but the codes below do not seem to
work.
Is it possible to have the ready made Form in Data Form
pop up with a code?

Sub ready()
Range("AS1").Select
frmDataForm.Show
End Sub

Thanks a bunch in advance











Sub ready()
Range("AS1").Select
ActiveSheet.ShowDataForm
End Sub