Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Cool Form

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

    Default

    I have a workbook with several tables. I would like a system of simple forms for users to navigate between, filling up the little text boxes and selected from cute drop down lists. The various table will be filled and bob's your uncle.

    The question I have is this:

    Can I have users fill in one form. and save it. The info will be stored in one row in the appropriate worksheet table.

    Then with the same form, the same text boxes etc. They add anothert record and the next row will be filled on said worksheet and so on on and so forth.

    Like in access

    I want them to be able to add as many records as they want.


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    NY
    Posts
    1,056
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sure -- simply find the appropriate row, like:
    TheRow = Sheet1.range("A65536").end(xlup).row
    cells(TheRow,1).value=Userform1.Textbox1.Text
    Cells(TheRow,2).Value=Userform1.Textbox2.Text
    etc.

    Bob Umlas
    Excel MVP

    On 2002-03-28 08:44, Matty2470 wrote:
    I have a workbook with several tables. I would like a system of simple forms for users to navigate between, filling up the little text boxes and selected from cute drop down lists. The various table will be filled and bob's your uncle.

    The question I have is this:

    Can I have users fill in one form. and save it. The info will be stored in one row in the appropriate worksheet table.

    Then with the same form, the same text boxes etc. They add anothert record and the next row will be filled on said worksheet and so on on and so forth.

    Like in access

    I want them to be able to add as many records as they want.


  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello: Bob's suggestion is the best approach if you don't mind the users being able to have easy access to the tables and if you will not have multi users updating the tables at the same time. If these are issues, however, you might look at using the Template Wiazrd with Data Tracking.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There's one thing I think Bob missed. Change this

    TheRow = Sheet1.range("A65536").end(xlup).row

    to this

    TheRow = Sheet1.Range("A65536").End(xlUp).Row + 1

    Because other wise you would be overwriting the previous contents.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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
  •