Option Boxes, Start Date & Foreground Coloring

Hi catnam

Here is something you can start off with. I changed the option boxes in your original file, to make is a bit easier to code for changes in the option boxes.

Please let me know how you get on.

Originally Posted by excelxx

Hi catnam

Here is something you can start off with. I changed the option boxes in your original file, to make is a bit easier to code for changes in the option boxes.

Please let me know how you get on.

Hi excelxx,

I most sincerely appeciate your help and your programming to start is working just fine. However, before we get to far along, I believe I should provide you the actual workbook (v3) which I want to use this in. I copies the code from v2 into module 1 of v3, but I could not get the radio buttons to copy over. Everything as far as the calendars are in the exact same location on sheet as in v2. So if you can please move or modify the option buttons I surely appreciate it. As you may notice, there is cell at top of calendars that allows you to select the year. This cause the calendars to change for the year selected, I hope you can make the coding work with this feature. Please note, I would like the FONT color to change, instead of background color, because background color indicate federal holidays.

Once you get it back to the point as in v2, please check out a few things I noticed:
1. After option button for Saturday is selected, it gets stuck on, even when I select another button.
2. Maybe this should happen, but when radio button is select in "I AM PAID ON" group, the selection in "I AM PAID" goes away.
3. For Monthly, the payday for each month should be the date entered below option buttons.
4. For Semi-Monthly, paydays can be 1st and 15th, or 15th and last day of the month.

I'm sorry if I've cause you too much trouble moving this to v3 or adding new requirements. But I do appreciate all your help.

catnam

Hi catnam

Currently on 2003 at the moment, and can't open the file. (it is refuses to convert)

It did notice the problem with the radio buttons not being independent of each group and I resolved that on a new version. I'll check the problem with the Saturday option button once I get to my Office 2007.

For the monthly option, if the user enters the 25th of January as being the first pay date, then the 25th of every month should be highlighted.

For the semi-monthly option, the only options which should be available to the user would be the 1st /15th or 15/last day of the month.

Thanks. That is correct for the monthly and semi-monthly options.

Hi catnam

I have made the changes as per your previous post.

Please let me know if you have any problems.

Regards

Hi excelxx,

This is looking good. The various selection combinations seems to be working once I get to a good starting point. However, the program seems to get a little confused when going from one selection combination to another, or when you change years. Maybe a button that will bring it to a clear default setting and some code that will on changing the year will it bring it to the clear setting will help. Also I was wondering if both the pop-up box and the cell for enter the date are necessary. Maybe just using the pop-up box will simplify things. I really apprecate this. It would have taken me months to figure this out.

Hi catnam

The macro did not have allowances for changing the years or leap years for that matter.

I have now changed the code to allow for the changing of years, in the clearing of the formatting and the calculation of the pay dates.

Also it also takes into consideration the leap years in the calculation of the pay dates.

Regards

Hi excelxx,

Everything works great!!! I really appreciate your help on this. Just one last question, do I still need the date cell below the days option group?

Thanks So Much
catnam

Hi catnam

You are welcome.

No you don't need the date at the bottom of the options group, as it is not being used by the code, it is only populated with the value that the user enters in the pop-up boxes.

Regards

Ps Please provide feedback using the reputation button. Thanks

Hi catnam

Please find attached an amended file, where the date for the bi-weekly selection is taken into account when highlighting the pay dates.

I haven't been able to sort out the issue with the Mondays. I did have a look at it and the code is formatting the cells as it should but I think the conditional formatting for the holidays seems to be taking precedence over the formatting for the pay date.

Regards

Thanks again excelxx. I want worry about the Monday thing.

Take care.
catnam