+ Reply to Thread
Results 1 to 3 of 3

Update List without closing User Form

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Update List without closing User Form

    In the attached example I can't add more than one name at a time without closing the user form. I can edit the list and click the "Save Changes" button and the changes happen. But using the "Add Name" button I can not add more than one name without closing the form, it just overwrites the previous name unless I close the form.


    Thanks

    Jim O
    Attached Files Attached Files
    Last edited by Jogier505; 02-17-2010 at 04:37 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Update List without closing User Form

    Change line as follows. Nothing goes in column A so this variable never changed.
    iRow = ws.Cells(Rows.Count, 4).End(xlUp).Offset(1, 0).Row

  3. #3
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Re: Update List without closing User Form

    StephenR,

    That appears to be the ticket.

    Thanks.

    Jim O

+ 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