Link to home
Start Free TrialLog in
Avatar of Max Hersey
Max HerseyFlag for Canada

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
SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Max Hersey

ASKER

I did not touch the coding, I just added new columns so perhaps that changed the coding columns. I didn't want any of the coding to change as it was all working good. I just knew that there were other things that needed to be added to the program so that It could do the job properly. I would imagine that by me adding new columns in the tabs most likely messed up the ranges in the coding.
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.
Yep! I honestly dont understand the coding so I dont touch it haha.
Can Saturday or Sunday ever be a workday?
Yep! usually more shiifts on that day because we need staff the 8 to 4 as well.
Theres a bunch of other ideas that I have after this is fixed. I will post them in a new question though.
Oh I just noticed that the AFT tab is supposed to be AFL
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?
should still be there
just hidden
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
I changed the AFT tab to AFL. I think that messed up the Calandar on the AFL tab.
Seems like the Calandar is only working for the first row on the AFL tab.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?