Could anyone help me build this Userform

Hi Dear All

I am HR Officer in Hospital. I need to have excel tool to manage and record staff leaves. I have built this excell sheet with macro but i failed to make it functional.
i attached here.
Please open this file attached and give me codes of the userform I bulid.

Please help me get if functionong..

if you could join me with another idea better design, i will cheerfully welcome and bless you

Best Regards
Axmed.cm

We are not here to do the work for you.

You need to ask specific questions.

How are we to know what you want or can't figure out for yourself.

use this code to populate your combobox when the userform initiates.

Please Login or Register  to view this content.

I am HR Manager at a Hospital. I made a tool for leaves monitoring. and it is attached here.

There are 3 kinds of leaves in my tool. Annual Leave (AL), Sick Leave (SL) and Amaternity Laeave (ML).
Every staff is entitled 24 working days of AL from Jan to Dec. so weekends and (inter)national holidays are excluded.
but weekends and (inter)national holidays are included in SL and ML as they are compationate leaves.

I have build a userform for entering this data in the excel.
bb.PNG

Pleae download the file to clearly see it, and help me have codes for userform i built.
Thank you in advance

Hahahaha, Excuse me dear!

THAT IS RALLY THRUE my friend.

Thank you for your helping...
if you do it for me then i will bless and thank you, also it is good practice and homework for you to try it, to know how active you are in excell.
thanxxxxx,thanxxxx, that is only what i can reward to you.

Once you have used the codes I gave you, what else do you want to happen in the UserForm?

Thanks Dear.

What I want to happen is:
After filling all fields, when click on Comandbutton1(OK) then

Data filled on the userform will autofills in the corresponding cells of the sheet.
as shown by this view:

l.PNG

Even I don't know it is possible..


thanks dear

Axmed.cm,

Check it out it's partially there.
I got rid of the Option Buttons and added a ListBox
I add a combobox for the StartDate so there would be no errors entered.

I haven't worked on the day issue yet, maybe you can figure it out.

Select Name from combobox
Select Type in ListBox
Select Days
Select Start Date
Click OK

Codes Used

Please Login or Register  to view this content.

GOOOOOOOOOOOOOOOD,

My dear overseas friend, DAVESEXCEL.
Thank you. you really saved more time for time.

100% its very well.
Just one thing if possible.....
uncout Fridays (weekday 6) when taking AL.
example: start leave 4 days AL for a person on Wed 1-18-15, then he/she wil take Wed 1-14-15, Thu 1-15-15, Sat 1-17-15 & Sun 1-18-15 (Friday not included).
but this is only for AL.
if it is impossible i will get rid of.
thanx a lot for giving me ur valuable time to help me.

See next post

I think this should work for you.

See attached

Yes. It is functioning as I needed.
Before you, I believed it is impossible. But now i can say everything may be applied in excel.
Then i must have special words to thank u.
you made my dreams true.

Hello my dear friend

I almost have my tool set up. and i started using it.
Just l am requesting you to do for me 2 things.
1. I added leaves by Unpaid Leave (UL), Overtime Leave(OL) and Compassinate Leave (CL), I want these leave to be like "AL" i.e to uncout Fridays.
2. I need to protect my document. is it possible to use the userform in protected cells?

attached here

Thank you veeeeeeeery muuuuuuuch

Give it a go, your password is "Password"

Please Login or Register  to view this content.

Dear Deves

When completted and clicked Commandbutton(OK), i need a message box telling me back due date.
like this
aa.PNG

Thaaaaanxxxxx a lot

Dear Deves

When completted and clicked Commandbutton(OK), i need a message box telling me back due date.
like this
Attachment 376331

Thaaaaanxxxxx a lot

ya, I won't be able to get to that till after work today.

Why don't you try and do it?

I will check back tonight on your progress.

ya, I won't be able to get to that till after work today.

Why don't you try and do it?

I will check back tonight on your progress.

Dear Daves.

I always updated it as the best as I could.
only I am asking you what got difficult on me.


[When completed and clicked Commandbutton(OK), i need a message box telling me back due date.]



attached

Thanks dear.

Looks good,
I can't help you though. the VBA project is password protected.

Sorry dear. Password is 11

try this,

Please Login or Register  to view this content.

Dear Daves


I am thanking you for your help and losing your time to answer my questions.

I feel this is a bit difficult for you. but I cant get someone else to help me.

I have the tool functioning well.
but sometimes it is not working. this problem is random.

it displays like this:

Capture.JPG

and when click debug button

it highlights some texts with yellow color like this:

Capture1.JPG

Thousand apologies for losing your time
Thousand Thanks for helping me

I hope this my last question.


The file is attached
all passwords= acm

What's in ComboBox2 when it fails?? Perhaps its unable to set fR

I am unable to replicate the problem, do you know what you have entered that produces the error?

Hi dear
Nothing else i entered.
Mostly this hapens when reopening the file after it is entered data and closed.
this is randomly.
Thanks for your reply

Thanx dear
No more problem. I will tolerate if it cant be solved.
it is sometimes.
what else insteed:

Is it possible to select cell of the last day of leave, when done? To see taken leaves in the sheet.

thousand thanks

See if this works,

Please Login or Register  to view this content.

Thanx Dear

It is working very gooooooooooooooooooood.
I tested several times, nothing wrong happened.

thanks a lot.

can I have the leaves taken selected after it's done.

Sory dear
You already did it.

it is ok. Also it selects last day of leave.
It is all updated.

Thanks my dear.
long live!!!!!!

Hello Dear.

I tested several times. it seemed it was OK.

But the problem still exists.

I am not good in English.
Did you understand me Sir?
Have you seen the problem in your side?

I am very disappointed...
very sorry to heck you.

I already told you that I can't replicate the error.

Thanks Dear.

You helped me more enough.

When I quit the file the VPA project Password flouts on desktop and can't be cancelled unless to click cancel button more times.

What is that??
is there a solution to disappear it??

thanks Dear

Sounds like it is a screen cling-on, not an excel issue.