Hi,
I'm a newbe and have been thinking about doing a project in Excel even though I don't have a lot of experience. I am currently learning the basics through tutorials. Someone said excel would be a good way of doing what I want to do and so I am asking anyone here to point me in the right direction. I want to write an Excel program for a restaurant menu. The menu will have a list of items with checkboxes. Every morning different items will be checked and those items will appear on a printable menu ready for the day. Eventually I want to have three columns of check boxes, one for each place in the menu I want it to appear, for example: breakfast, lunch and supper. Hope someone can help.
Thanks in advance.
Last edited by dal1al10; 02-02-2012 at 12:19 AM.
Hi dal
Sounds like you want something quite involved for a first project. I've reproduced a menu example using Vlookup that I came across when I was first getting into the world of spreadsheets (about 6 months or so ago).. It's something to look at & start you off
Have fun
I have drafted something for you, which you can start on. Find attached an example. The first sheet has the dishes (for now its B1 for Breakfast Dish 1, L1 for Lunch Dish 1 and D1 for Dinner Dish 1 and so on). Instead of complicating the whole example with checkboxes and their associated programming, i have formatted the font in those columns with webdings, which gives me a tick mark if i enter "a". Based on that, once you select the button, the menu will be ready in the 2nd sheet.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks