Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
John,
Try this Private Sub userform_activate() ListBox1.ColumnCount = 20 ListBox1.List = Range("A1:U" & Application.CountA(Range("A:A"))).Value End Sub -- HTH Bob Phillips wrote in message oups.com... hi, i have a list box on a userform that displays dta from a part of my spreadsheet. the list will have a different number of rows at different times but always the same amount of columns. I have worked out that there will never be more then 200 rows to display so i am currently using private sub userform activate listbox1.columncount = 20 listbox1.list = range("a1:u200".value end sub this ensure i get all the dat into the listbox. can i make it smarter so the list box only displays rows with data in rather then all 200. Although this method seems to work sometime whne i run the program i am unable to select certain rows within the listbox. i.e i may have 20 rows in the listbox and i can only highlight 17 of them. regards john |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I populate a drop down list from Data Validation? | Excel Discussion (Misc queries) | |||
Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
populate data valadation list by criteria | Excel Worksheet Functions | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) |