A community for students.
Here's the question you clicked on:
 0 viewing
anonymous
 4 years ago
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.
anonymous
 4 years ago
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.

This Question is Closed

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Hi guys, do you have any idea?

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Buddy, 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.

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Thanks 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)

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0Sure, 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!

anonymous
 4 years ago
Best ResponseYou've already chosen the best response.0I found this: http://www.mrexcel.com/archive/Controls/12646.html hope it works with my problem. Thanks bro!
Ask your own question
Sign UpFind more explanations on OpenStudy
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.