+ Reply to Thread
Results 1 to 4 of 4

data inserted in rows disappears

  1. #1
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    115

    data inserted in rows disappears

    Hi everybody,

    I have a Wsheet with 8 textboxes. The first 5, when saving the data to the wsheet from the userform has the following code:
    Please Login or Register  to view this content.
    The last 3 textboxes have a different code:
    Please Login or Register  to view this content.
    My objective is that the data from the 3 last textboxes goes to the three rows below and, when i enter a new record, the data goes to the row below the row where the textbox11 was inserted.

    My problem is that, when i insert a new record, the data from those 3 textboxes dissapeare.

    Can anyone help me with this?

    I think that the attach file should explain it better
    Attached Files Attached Files
    Last edited by ncaravela; 10-15-2010 at 12:03 PM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: data inserted in rows disappears

    Hi ncaravela

    try change the select code to

    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: data inserted in rows disappears

    or this
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    115

    Re: data inserted in rows disappears

    Pike,

    Thanks for your help. However, there's a detail that i forgot to mencione.
    Not in every record i need to fill in the three textboxes (9, 10 and 11).
    Sometimes i just need to fill in txtbox9, sometimes 9 and 10...

    When using your code, if i don't fill in the three txtboxes, i get one or two blank rows.
    I've tryed adding the following code, to delete blank rows, in amodule, but it's not working.

    Please Login or Register  to view this content.
    can you help me?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1