A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • 5 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
  1. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    1 Attachment
  2. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hi guys, do you have any idea?

  3. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

  4. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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)

  5. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 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!

  6. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

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

  7. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

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
  • 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.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.