Hi,
I thought I had this fixed, but it's not exactly what I'm looking for.
This is what I have on my UserForm:
I have a SalaryListBox with four possible Values. I Have a Utilization TextBox which I would like to display as a percentage.
Student1.JPG
I need a formula that will take the Value for SalaryListBox multiply it by 7.5 (Hours in a Day) multiplied by number of days (DTPicker4)-(DtPicker3) and multiply by Utilization.
When I don't set the Utilization format a Percentage it works fine but, the User enters 1 and it shows up as 1 instead of 100% which is confusing.
Below is how it looks with the formula working:
This what I would like it to look like, but the Code isn't working (Code below):
Student2.JPG
Can anyone tell me where my error is and how to fix it??
Thank-you in advance.
Bookmarks