+ Reply to Thread
Results 1 to 7 of 7

Multi Column Listview

  1. #1
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Multi Column Listview

    Hi Expert,

    I have requirements to create a data entry in excel using Userform with Listview control.
    the required columns. the function is can be add, edit and delete and save records.

    is this possible to add, edit and delete records in list view? i'm using excel 2010.
    Btw, i already have an initial userform with list view control.
    your help is very much appreciated. thank you.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Multi Column Listview

    can you attach a sample xlsm file ?
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Multi Column Listview

    Thank you patel45 for your reply.
    Upon searching from the net i did not see any Listview pabale to edit delete records.

    I come up with a solution instead of edit and deleting records in the list view i need only to save the records from the textbox in the listview before
    saving the transaction. the user can review the records before posting it. I've create a temptable to save the records entered from textbox using Posting button.
    for ex. in 1 ticket number it has a multiple records, so i have to enter those 4 records in listview before saving the transaction to TransactDB.

    Btw, how could i attached a sample xlsm file here excelforum? Thanks.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Multi Column Listview

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Multi Column Listview

    Thank you very much.

    Please see attached xlsm file.

  6. #6
    Forum Contributor
    Join Date
    07-17-2011
    Location
    PH
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Multi Column Listview

    Thank you very much.
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Multi Column Listview

    I can not see any listview

+ 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. Display data in ListView upon specific text in column Y
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 05:51 PM
  2. 1 column into multi-columns and multi-rows
    By affj in forum Excel General
    Replies: 7
    Last Post: 07-17-2013, 09:34 AM
  3. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  4. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  5. Multi-Column Listboxes correspond to multi textboxes
    By Crebsington in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2012, 01:38 PM

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