In this vba. in this event i select the date then press get data button.......
that time . i populate values from similar page "ATTN" and get "Date" Column staff details to user form.
If the staff is leave------- listbox leave to populate.
If the staff is Night------ listbox Night to populate.
If the staff is day------- listbox day to populate.
If the staff is blank----- listbox 3 to populate.
Please Help Me.....
Put this in your Userform code module.
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks