Listbox issue + Setfocus after property Issue

Hi Kindly help me solving my issue.

Please refer attached macro, Its a small Project for a school.

My issues :

1. In the Userform1, If we enter a Previously assigned Admission No , it will show as its already assigned to some student which is correct Example Search for S01. but its set focus is lost, I want the set focus to be back on Admission_no

2. In the Userform3, this is for viewing student history. I am unable to get the filtered data on the list box. which currently managed by copying the filtered data from sheet Student_data to another sheet Payment_ History and then displaying that full data on the listbox LS1. which is not feasible actually because I have another more filters to add-on like.
Paid and outstanding to show on list box based on search type. (through command buttons Cleared and Outstanding on the userform) - Cleared should show filtered result taking the values of that rows where balance amount(column L) is Zero in the excel, and <>0 for Outstanding.

so I need filtered data to show on listbox based on filter.

Pls help me here.

For Userform1 , not after update but in Exit

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo, Superb yes its worked for me same I followed your code and changed to Exit. Thank a million.

Appreciate if you could solve my 2nd issue as well with Listbox

no, i use also helper sheet
other method is with loop and listbox.additem, but this is time consuming

Kind regards
Leo

Made dynamic named range and this codes for buttons
in listbox properties
change headers to true
columnscount to 15

Please Login or Register  to view this content.

Oh really cool... I have no words.. Fantabulous Leo thanks a million, you have made my day.

Hi Leo, Sorry for bothering again, Need help here in 2 things. pls refer my new attachment.

1. Check Userform3 and Enter Student ID as S01 and search, then Click Outstanding, Then select a row and click Pay selected button , Here my issue comes.
It acquiring correct row number and appearing in message box but its not passing the same value to the label Caption in Userform5.

2. I Prefer to extend my listbox selection items to multi by changing the Listbox LS1 Multiselect option to frmMultiselect option, Here my Requirement is Selected Row numbers in the list box need to should in message box and also pass the values to an array.

My idea is to use these array row numbers to accumulate outstanding of selected rows only and can be used to pay in userform5.

Regards

No idee what result you expect in userform 5
so lets say when you select student S01, choose outstanding, here you select rows 2 and 8
witch result have to be in userform 5 ?

you can enter this values manuel in new exemple ?

Kind regards
Leo

1 column with Name
1 column with nr
1 column with Date
1 column for what has to be paid
1 column for what is paid

for every payment or new debt, one new row
this is the only logic to work with in userforms and listboxes

Kind regards
Leo