+ Reply to Thread
Results 1 to 3 of 3

edit in code for populate range of cell in list box and code for delete any items

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    edit in code for populate range of cell in list box and code for delete any items

    HTML Code: 
    the problem in this code as the following
    in column E data want to listed without decimal number
    second want explain how i understand how can calculate .ColumnWidths = "100;20;50;50;20" because i take copy past
    third
    want code to allow to delete any items select from list and delete from (waiting list) sheet its Row
    please note this list box present in userform4
    see my attached photo
    i find this code online but its delet only from list box without delete from sheet
    HTML Code: 
    Also need to make this code for listbox show only row have data now all row in the range
    Attached Images Attached Images
    Last edited by mazan2010; 07-11-2017 at 02:58 PM.

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: edit in code for populate range of cell in list box and code for delete any items

    i find this code and try to used it but give me error
    HTML Code: 

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: edit in code for populate range of cell in list box and code for delete any items

    this another code for delete but can't edit in this because with my edit give me
    HTML Code: 

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Edit code to cover range instead of individual cell
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2015, 10:52 AM
  2. VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2015, 07:48 AM
  3. Code look through range of cells, find blanks & delete cell range in the same row,
    By EagleInsight in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2014, 11:24 AM
  4. [SOLVED] Edit VBA code to select last cell in named range
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2012, 04:34 AM
  5. Safe Way To Have Users Edit List Of Items In Named Range
    By Spencer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2011, 11:25 AM
  6. Select, Edit, Add & Delete items in a list box
    By baisty182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 07:25 AM
  7. [SOLVED] i want to delete duplicate items in a list using code.
    By ndm berry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2005, 10:05 AM

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