listbox on userform not showing specific cells

**cfinch100** · 02-23-2013, 11:20 AM

hi
just had 2 hrs trying to sort this one out on my userform frmmfrsa it has 2 instances of listbox column widths not sure which one its using
it has first 6 columns on it now want column 16 or posted and no others,
the other form frmmfrsanew which is a copy of first form has cost missing,but i presume if first one can be sorted id just do same for this
have tried 15,67,78,ect and 56;67;78 ect, anyone can tell me which its using please
cheers colin

**Sean Thomas** · 02-23-2013, 11:43 AM

of what i can see, your userform intialise code set the listbox to 7 columns
but your cmdsearch code doesnt change the columns

you could try to set the columns
just add

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**davesexcel** · 02-23-2013, 12:04 PM

Your code is setting the columnCount to 7 but your ListBox properties have the column count set to 16.
You need to Dim Data as range
At the end of your code you are clearing the control

Please Login or Register  to view this content.

**cfinch100** · 02-23-2013, 12:14 PM

hi sean
thanks for that but does not do what i need lists few more , ive deleted ,put 0 as size but does not let me list a,b,c,d,e,f and q
thanks though will keep trying
cheers colin

**cfinch100** · 02-23-2013, 12:29 PM

hi
tried this one aswell comes up with this

Please Login or Register  to view this content.

and only lists 5 columns and no headers
thanks for help though
cheers colin

it was this line in cmdsearch that was causing problem

Please Login or Register  to view this content.

have moved them all along and put 0,s for columns not wanted and now shows a to f and q which is posted
thanks for help solved this one myself nearly a first
cheers colin