Excel Data Entry Form
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Excel Data Entry Form

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

    Default

     
    I have an Excel data entry form and after I save the data I would like the form to automatically refresh to accept new data. Is there anyway to do this without closing the worksheet and then re-opening?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i don't understand, do you already have code that opens the data entry form when you open the workbook?

    If so, there is no similar event for AfterSave, as it were, but you could add a button to the page to allow the data entry form to open up when you click it...


    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe David Z is referring to DATA|FORM a virtual Data Entry Form that is generated within the worksheet wihout any VBA code. The form is virtual and volatile. After you are done with entering the data the form is gone. You have to ask for the DATA|FORM to show up every time you want to use it!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    understood, but question implies that this form is already triggered OnOpen.

    This form can be triggered using VBA, if required, and this trigger can be attached to a button, eg...


    sheets("sheet1").Columns("A:C").Select
    ActiveSheet.ShowDataForm



    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Good thinking daleyman ...
    I may have misjudged David Z's intent.
    THANKS!

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
  •  

 

 
DMCA.com