Thread
:
DataForm.Show does not work in code
View Single Post
#
8
Posted to microsoft.public.excel.programming
Toppers
external usenet poster
Posts: 4,339
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
Reply With Quote
Toppers
View Public Profile
Find all posts by Toppers