Entering Data into tabel form a Userform

[SKEEEETER]

Using the Microsoft template for Employee Attendance Tracker I have created on and modified it with help form users on here. I have the data added to a table on a sheet from a user form.this all works as I want.

The issue is that on the main sheet that data in the table is used to produce a visual calendar of the year. It colors each day depending on the dates enter and type of leave taken. Originally you entered data into the table directly your selection was done via data validation.

When you enter the data in by selecting the cell in the table from the data validation list it all works. But when it is added via the user form it indeed adds it to bottom of table. But for some reason this is not then displayed on other sheet with the calendar.

I am hoping someone can figure out why and assist me with this. I have tried to attach file here and some pics of screen but buttons here don't seem to work at all.

Please Login or Register  to view this content.

This is the code that adds the data form form into the table this does indeed add it to the table.

[pjwhitfield]

I dont think the issue will lie with the data entry code, chances are its in the code to produce the calendar. It could be that the calendar code looks to a certain column (that isnt completed on the form) or that a user event which runs on data entry but not the form entry updates something.


Can you upload the workbook?

[SKEEEETER]

Yes I have looked at the sheet with calendar, but have been unable to work it out. If I enter it via the user form it adds to table then if I manual enter it via the cells in table the manual shows but not the one that has been form the User form.

https://dl.dropboxusercontent.com/u/...ngappluad.xlsm

Not sure if this will work

[pjwhitfield]

I cant access dropbox files at work, can you upload through the forum? in a reply click the Go Advanced button and then Manage Attachments.

[meabrams]

I think it’s just the way you have your date set to format on your userform. I made an adjustment to the format of the date on the calendar userform and it seems to allow for the table to not have the calculation error. Then on your table I did a custom format of the cell to set it back to the dd/mm/yyyy format that you are using.

Change Code on both frmCalendar and frmCalendar2

Please Login or Register  to view this content.

[SKEEEETER]

Thanks that indeed has fixed the issue thanks so much

[SKEEEETER]

Seeing you were able to help with that, I wonder if you may know the answer or the code to do this. I am not sure how to explain it in a a forum heading, as it is to do with the same file you have modified. This file keeps a record of leave taken, I need to be able to generate a report that takes the date that you run report and shows a list of people that have had no sick leave for the last 3 months. So say on the 1st of March you run it it displays whom has had no time off from the 1 Dec to 1st of March. I am not sure where to start with it.

[SKEEEETER]

I think it’s just the way you have your date set to format on your userform. I made an adjustment to the format of the date on the calendar userform and it seems to allow for the table to not have the calculation error. Then on your table I did a custom format of the cell to set it back to the dd/mm/yyyy format that you are using.

Change Code on both frmCalendar and frmCalendar2

Please Login or Register  to view this content.

Hi again this works great but issue I have here in Australia we enter our Dates as dd/mm/yyyy. When you select the date form the calendar popup it displays it as the is mm/dd/yyyy. I have tried to change it to show as dd/mm/yyyy but then does not enter it into table, I assume there is some code in the calendar module perhaps that needs changing.