Hi and ty in advance.
First of all I have no experience in vb, vba or any type of coding. So please try to explain it as simple as you can.
Here's what I would like to do, if at all possible. I want to create an excel workbook schedule with 13 pages. First page will have a calendar on it. The rest of the pages will be months. I would like to use a calendar control and if clicking on a date, it will jump to a specific sheet and cell.
I.E. You select January 1st on the calendar, it takes you to Sheet January and cell A1. If you were to click on January 2nd, it would take you to Sheet January and cell H1, if you click on January 8th it would take you to sheet January and cell A20, and so on. Is this possible or would I have to physically make a calendar with hyperlinks to where I want to go?
First of all I have no experience in vb, vba or any type of coding. So please try to explain it as simple as you can.
Here's what I would like to do, if at all possible. I want to create an excel workbook schedule with 13 pages. First page will have a calendar on it. The rest of the pages will be months. I would like to use a calendar control and if clicking on a date, it will jump to a specific sheet and cell.
I.E. You select January 1st on the calendar, it takes you to Sheet January and cell A1. If you were to click on January 2nd, it would take you to Sheet January and cell H1, if you click on January 8th it would take you to sheet January and cell A20, and so on. Is this possible or would I have to physically make a calendar with hyperlinks to where I want to go?