Hi
I'm new to using objects and VBA on Excel and I don't even know how to approach this assingment.
What I need to do: I have 13 sheets, one for each month and "settings". On sheets, there are dates on two colums, 1-16 on A and 17-> on D. I need drop-down boxes after each date, and Dropbox is populated by data from "settings" sheet.
But its obvious, first box is linked to B3(or actually janyary!B3), and it's really unefficient to manually chance linked cell in every box.
I have Finnish version, so I think this is combobox.
I'm new to using objects and VBA on Excel and I don't even know how to approach this assingment.
What I need to do: I have 13 sheets, one for each month and "settings". On sheets, there are dates on two colums, 1-16 on A and 17-> on D. I need drop-down boxes after each date, and Dropbox is populated by data from "settings" sheet.
But its obvious, first box is linked to B3(or actually janyary!B3), and it's really unefficient to manually chance linked cell in every box.
I have Finnish version, so I think this is combobox.