I am working on a simple excel calendar with a combo box containing hyperlinks to each month. All months are on the same sheet starting June 1st.
I have a Name range - all months (Hyperlinks) and name range (Linked_cell) the combo box is assigned to each range and the hyperlinks have all been tested and route to the correct cell. however, when I use the combobox, the first two months (June, July) go to the August cell.
It is something in the code but I have tried amending with no luck.
Can anyone help with the code?