I'm such a dabbler at code writing but, as everyone does I have a "big Idea". Mine is to build a Job Log for work that will help with tracking projects and save time due to the redundancy of the required paperwork. I have been working on it when time permits and have been actually using it in the field for the last couple years. It suffices, but is somewhat inadequate and is not user friendly for others. Therefore, I am now re-writing it to clean it up, fix issues and add items and functions that will be helpful.
Any help anyone can give is quite appreciated as my code writing skills are very beginner level.
I have (1) workbook with (1) Master sheet called "Time Cards" which selects (10) individual sheets called "Job logs". They are referred to as Job Log 1 through Job Log 10. I have a "T & M" check box on each Job Log which toggles the text in a button on each Job Log sheet to read "Labor Form" or "Job Invoice". Our Time & Material projects require different paperwork.
The check box works to toggle the text, but I'm stuck as to how to build the code for the button to change the sheet selection. The below is the working code I currently have in place.
There are 10 buttons, on 10 job logs, toggling between 10 each Labor Forms/ Job Invoices. All working separately. IE Job Log 1, Labor Form 1, Job Invoice 1, Job Log 2, Labor Form 2 etc.
All sheets are hidden until called upon by its corresponding button. They do not need to re-hide themselves as I have a single macro attached to a return to Time Card Button on every sheet that hides all but the master time cards sheet.
Sub JumpToLaborForm1()
' JumpToSheet13 Macro
Sheets("Labor Form 1").Visible = True
Sheets("Labor Form 1").Select
End Sub
I look forward to any help provided and thank you very much ahead of time.
Any help anyone can give is quite appreciated as my code writing skills are very beginner level.
I have (1) workbook with (1) Master sheet called "Time Cards" which selects (10) individual sheets called "Job logs". They are referred to as Job Log 1 through Job Log 10. I have a "T & M" check box on each Job Log which toggles the text in a button on each Job Log sheet to read "Labor Form" or "Job Invoice". Our Time & Material projects require different paperwork.
The check box works to toggle the text, but I'm stuck as to how to build the code for the button to change the sheet selection. The below is the working code I currently have in place.
There are 10 buttons, on 10 job logs, toggling between 10 each Labor Forms/ Job Invoices. All working separately. IE Job Log 1, Labor Form 1, Job Invoice 1, Job Log 2, Labor Form 2 etc.
All sheets are hidden until called upon by its corresponding button. They do not need to re-hide themselves as I have a single macro attached to a return to Time Card Button on every sheet that hides all but the master time cards sheet.
Sub JumpToLaborForm1()
' JumpToSheet13 Macro
Sheets("Labor Form 1").Visible = True
Sheets("Labor Form 1").Select
End Sub
I look forward to any help provided and thank you very much ahead of time.