Hi , I am getting error at below line., I could not get any idea why its giving error.
Please check attachment excel, and click on Admission and then Click "+" in Siblings.
It should show Combo box named Ref1 and it should be populate the list of Admission No's
Due to File size restriction I am unable to load File.
Why not upload a stripped down workbook?
If posting code please use code tags, see here.
Hi, I Removed all unwanted forms from the this excel just to upload.
Pls refer attachment and click on Student View button and then select any color button and see the error and advise what is the error.
I'm not getting the error on the line you indicate, I'm getting it on this line in sub Fill_Listbox1.
In fact I can't find the code you posted in the attached workbook.
Please Login or Register to view this content.
PS I think the problem with the above code is that you can't use AddItem/List to populate a listbox with more than 10 (?) columns.
in listbox properties columnscount @ 12
columnwidth @ 35 pt;120 pt;35 pt;90 pt;0 pt;0 pt;300 pt;0 pt;0 pt;90 pt;90 pt;0 pt
Please Login or Register to view this content.Kind regardsPlease Login or Register to view this content.
Leo
forgot the file
Cheers
Leo
Or just filter in ListBox, that way you don't need AutoFilter or extra sheet.
Please Login or Register to view this content.
Last edited by bakerman2; 04-05-2018 at 08:45 PM. Reason: Added Studentcount in label.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you Leo and Bakerman2 Both your methods worked absolutely fantastic.. 1 small thing to be added, I need Header as well, pls assist.
You can't have a header in a listbox unless you use RowSource to populate it.
One way to do it.
Only downside is when scrolling down headerrow will also disappear.Please Login or Register to view this content.
Last edited by bakerman2; 04-06-2018 at 02:06 AM.
You have made my day fresh and long , thanks a million bakerman, this issue was my show stopper and you have resumed it.
Glad to help and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by bakerman2; 04-06-2018 at 06:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks