LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Standard Module Code from Dataform Jim May Excel Programming 1 September 29th 05 04:08 PM
How to activate "New" tab in Dataform through VB Code shajueasow Excel Discussion (Misc queries) 2 May 1st 05 01:15 PM
Dataform Mark Excel Programming 3 February 14th 05 12:59 PM
dataform Enrique Bustamante Excel Programming 1 August 26th 04 01:30 PM
VBA code to show a save as dialog does not work Kevin Excel Programming 4 November 17th 03 08:36 AM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"