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: 147
Default Show Data Form

I am trying to write a short and simple macro that will bring up the data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields for
the other 10 categories as well. But when I click on Data and Forms myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?
 
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
Data Entry Form (similar to default Excel DataForm) tonydm Excel Programming 0 October 11th 05 07:59 PM
Show Data Form David Holtby[_2_] Excel Programming 0 October 20th 04 01:48 PM
Show Data Form David Holtby Excel Programming 1 October 18th 04 05:03 PM
Help! Animated gif-image in form does not show animation when form loaded JoCa Excel Programming 4 September 23rd 04 07:43 PM
How to show External Data Options form Jan Karel Pieterse Excel Programming 6 October 8th 03 09:13 AM


All times are GMT +1. The time now is 03:12 PM.

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

About Us

"It's about Microsoft Excel"