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