listbox RRS feed

  • Question

  • I want to edit excel sheet in listbox on userform. The range is very big. Data in this range is only in 10 columns, rest are having value 0 or empty, while total column number is 180.  List box appears on depending on the selection by a combobox on userform. I want this list box to select only two rows at a time, one top heading row and second the same this combo box selects. If list box select only those columns in a row that have values 1 or above, it will be great advantage. Here I want to edit it in list box as we can do in cell of worksheet and send back to worksheet.

    please help,



    Monday, October 27, 2014 8:57 AM

All replies

  • You need to better describe your setup, with an example where you explain how you want to choose what appears on the listbox.
    Monday, October 27, 2014 5:49 PM
  • Hi

    Many thanks,

    I have long rows with 1-15 columns having value. I want this value appear in userform in any way, like textbox, listbox etc. and go to next empty row in the same column. These should be an option to edit it if needed.

    Is there any way ?

    It does not allow me to post image, I do not why ?



    Sunday, November 30, 2014 3:08 PM