View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ufo_pilot ufo_pilot is offline
external usenet poster
 
Posts: 142
Default 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