Max Hersey
asked on
Fix VBA in File and Add Calandar on AFT tab
I added a few new columns into the staff tab and the AFT tab. I also added in the rest of the year for the house tabs. This seemed to mess up some of the VBA that has been written for my program. Can this be fixed? Also, I was wondering if the Shift date tab could have a calendar drop down rather than writing in the date.
Thanks!
Dec-30th-Schedule.xlsm
Thanks!
Dec-30th-Schedule.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That Calandar thing works really nice tho! any chance we could add it to column C and D of the Staff tab as well?
Okay, I was wrong, but you did change the the sheet name and other non-coding things. I assume then that you just want to add a calendar and have everything else work as is.
ASKER
Yep! I honestly dont understand the coding so I dont touch it haha.
Can Saturday or Sunday ever be a workday?
ASKER
Yep! usually more shiifts on that day because we need staff the 8 to 4 as well.
ASKER
Theres a bunch of other ideas that I have after this is fixed. I will post them in a new question though.
ASKER
Oh I just noticed that the AFT tab is supposed to be AFL
ASKER
Im also messing around with the calandar and it wont let me enter in a date for some reason. I can click on a date but it wont enter it into the cell.
I'm fixing that now.
What happened to the data that used to be in col 'L' of the AFL sheet?
ASKER
should still be there
ASKER
just hidden
ASKER
Oh i had to add a column to the AFL tab so it bumped it to M
Try this. I used a modified version of the calendar supplied by Roy. The calendar will show up on the AFT and Staff sheets
29130957.xlsm
29130957.xlsm
ASKER
I changed the AFT tab to AFL. I think that messed up the Calandar on the AFL tab.
ASKER
Seems like the Calandar is only working for the first row on the AFL tab.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I wasn't familiar with your code, but I saw the line that I indicated didn't seem to refer to the correct range assuming you had added a Column.
Are you working with my calendar?
Are you working with my calendar?
ASKER