DataForm.Show does not work in code

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Check the Userform name is correct

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

 

[Guest]

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.

 

[Guest]

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".

 

[Guest]

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.

 

[Guest]

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

If you want, post your workbook to me - (e-mail address removed) - and
I'll look at it offline.

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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

 

[Guest]

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

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

 

[Guest]

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...)

 

[Guest]

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

 

[Tom Ogilvy]

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