none
Transfer data from worksheet to User Form RRS feed

  • Question

  • I have a project that saves information to a workbook. I added a user form to show the data in specific sheet. ex get the data from worksheet(1) to fill the text Boxes in My user form.

    say sheet(1) has columns named: Paydate, chekNum, Payeename, Detail,Amount.

    and say there are 9 rows with data.

    How can I Extract the data from the Worksheet to the nuser form???? 

    Friday, November 15, 2019 4:09 PM

All replies

  • You could place a ListBox control on the userform.

    Set its ColumnCount property to 4 (the number of columns that you want to display), and its RowSource property to the address of the range that you want to display, e.g. Sheet1!A2:D10


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, November 15, 2019 7:26 PM