hi, i have made a form in which i have add a list box to display the data of the sheet for a particular range.
i can view all the data along with empty rows of the selected range. i don't want to see the empty row how can i do that.
Attached image of my form and sheet.
VIEW.png
Many Thanks in advance.
BR
Cool Sab
Hello
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
hi yasser bhai, i can't run the form, as it shows run time error 70 permission denied
Please Login or Register to view this content.
Perhaps...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Make sure you don't specify rowsource for ListBox1 ...
It is better to upload sample of your file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks