+ Reply to Thread
Results 1 to 6 of 6

Recipe Database save sheet

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Recipe Database save sheet

    I sure could use some suggestion on this,or if it is possible to do. On sheet two I have a template for data, would I have to make a new sheet for each recipe?. what I was hoping to do was open the userform and select a group and have it fill the listbox. How would I save each sheet to a group, I need a lot of suggestions. If this is a waste tell me now before I get to deep into this. I tried to find some example on this subject but no luck. Not sure how many she has maybe 750 or so.




    Project Closed Z
    Attached Files Attached Files
    Last edited by zplugger; 02-12-2011 at 07:28 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Recipe Database save sheet

    IMO, Excel is not convenient for recipes, and the necessary minutia of forms may not be something you want to jump into if you're just getting into VBA.

    I use a simple Word template for 5 x 8 cards that has a style for ingredients (a right tab for qty followed by a left tab for ingredient) and another style for instructions.

    The only recipe I have in Excel is one for popovers that can scale for quantity.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Recipe Database save sheet

    Thanks shg
    I respect your advice and will not go on with this. I will try and find some Word examples for this project. Mabe I should look around and just a program. You have a good Weekend and thanks again for your help.
    Z
    Last edited by zplugger; 02-12-2011 at 07:08 PM.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Recipe Database save sheet

    Here's my template, and two recipes to go with it.

    There are only three styles: Title, n (Normal), and i (ingredient).

    Save me leftovers if you cook anything good.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Recipe Database save sheet

    Thank You, I will take a look. I just need a quick way to sort and find the different groups.

    Z

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Recipe Database save sheet

    Suggest you arrange recipes by directory, e.g., Recipes\Entrees\Beef\PeppercornSteak

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1