Question

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.

Answer 1

Hi guys, do you have any idea?

Answer 2

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.

Answer 3

Thanks mauodias!
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)

Answer 4

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!

Answer 5

I found this: http://www.mrexcel.com/archive/Controls/12646.html
hope it works with my problem. Thanks bro!