Need Help With Macro

Closed
Neo - Jul 26, 2010 at 11:56 AM
 Neo - Aug 6, 2010 at 12:23 PM
Hello,

I have attached a sample of what I would like done.

https://authentification.site/files/23532726/SAMPLE.xls



2 replies

can anyone help with this ?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 30, 2010 at 08:08 AM
I think you have a similair solution done before. it was for some other column but idea was pretty much same
0
I have removed the password from the file, so that you can see what macros currently exist. I don't believe any of them will do what I want done in this instance. Thanks

https://authentification.site/files/23589974/SAMPLE.xls
0
can you remodify the code to add what I want done.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 6, 2010 at 11:27 AM
no file found
0
https://authentification.site/files/23689353/SAMPLE.xls

This is how I envision this working. At the beginning of the year column L will be filled in with a range of numbers ranging from 0 to a maximum value of 10, at this point whenever an S is entered 1 must be subtracted from the total in column L, if this total is 10 then it would then be 9, if the total is already zero, then the message box would appear at this point, prompting the user that there are no more sick days available. The message box only appears when the total in column L is at zero and the user attempts to enter S.

The employee gets back his sick days on his anniversary date, eg. the hire date for someone is 1-20-90, the number in column L has to automatically be reset to 10 on this date, 1-20-2011, so if the number in Column L was 2, then it would go back to 10. When this happens the cycle outlined above will repeat itself.
0