Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
DataForm.Show does not work in code
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Standard Module Code from Dataform | Excel Programming | |||
How to activate "New" tab in Dataform through VB Code | Excel Discussion (Misc queries) | |||
Dataform | Excel Programming | |||
dataform | Excel Programming | |||
VBA code to show a save as dialog does not work | Excel Programming |