Consulting

Results 1 to 2 of 2

Thread: Transfer row from list box to another sheet VBA

  1. 02-15-2017, 06:20 PM #1
    prospice
    prospice is offline
    VBAX Newbie
    Joined
    Feb 2017
    Posts
    1
    Location

    Transfer row from list box to another sheet VBA

    Need help I need to TRANSFER data totally from listbox, meaning if i transfer the data from sheet 1 to sheet 2 the transfer data must not be visible on the sheet 1 just like cut and paste?

    Thanks you!

    Regards,
    Russel

    Please see attached file
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 02-16-2017, 01:53 PM #2
    SamT
    SamT is offline
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Listbox1.TopIndex relates directly to Sheet1 Row number . . so Sheet1.Rows(Listbox1.TopIndex + 1).Delete
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules