Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Data Form

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want a Data Form for my spreadsheet just like the one you get by clicking Data>Form on the menu bar but I want to be able to edit it in VBA. Is there a way to get one without learning lots of VBA code? I'm still a beginner on VBA. Thanks.

    Jason

    [ This Message was edited by: jsinnr on 2002-04-29 11:51 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    North Alabama, USA
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Away to get started is with the macro recorder. Go to Tools, Macro and Macro Recorder. Name your macro anything for now you can change it later. Step through constructing your form and then stop the recorder. Now you can go back with Alt-F8, select your new macro and edit to see what you have done.

    The VBA for Dummies book is a good starter.

    HTH

    Rocky...

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks. I was hoping to find a way to view (or copy) the code of the data form that Excel provides when you select a cell in the collumn name row and click Data > Form so I can add a command button with an event procedure.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •