I'm trying to make a combobox in excel such as I can choose the date and the worksheet gets filled with appointments for that day.
Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.
Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
Buddy, I've made something similar some days ago. It was pretty simple and without any smart engineering. In a particular area of your sheet you will write the days of the week and in the cell you want to show the Combo Box you will use a Data tool. Right now I don't remember exactly how I did this and I don't have Excel installed here, but I will do it soon and, if you've got no answers yet, I can give a better approach.
So, after doing it, in the cells you want to fill, you can use chained conditionals (if, else (if, else(if, else))) and so it goes.
That's a pretty dumb and simple approach, but I'm not very sure about Excel's programming possibilities. I'm sure that this way works. As soon as I have more details, I can provide it.
Not the answer you are looking for? Search for more explanations.
I wanted to do that, but I think It does not look good. So I'm doing init VBA. I think I'm doing it good. I will let you know if I succed =0)
Sure, it REALLY does not look good. I've made it in a few minutes, just to make a sketch of my university schedules, and I have no VBA knowledge. If you reach a good solution with this approach, please, let us know! Good luck, bro!
I found this: http://www.mrexcel.com/archive/Controls/12646.html
hope it works with my problem. Thanks bro!