Need help with programming parts of a worksheet for an ongoing flowchart

[learningtoexcel]

Hello,

First, I'd like to start by making it clear that I'm new to using VBA and Macros with Excel. With that said, I do pick up quickly. I just don't have the programming knowledge to put my plan into action.

In short, I'm trying to develop a compounding flowchart for my wife's new business she is starting. The concept is simple but there are some conditions that need to be programmed into certain areas of the worksheet to accommodate Excel functions that will build off of existing calculations.

I have figured out how to add a button and attach a macro that allows for input and a calculated output. But the macro only accomplishes one part of my goal.

I have attached the worksheet so anyone that might be able to help can see first hand what is going on before any potential assistance. So, if anyone is interested in taking a look, I would be glad to give you all of the details that you need to understand exactly what I'm looking to do.

Thanks in advance for anyone's help!!

[pjwhitfield]

Obviously, without knowing what the problem is its difficult to give any guidance.

From 1st view the sheet appears to be performing as required? Is it that you want something additional adding? if so, then if you can give a description of what you want I'll happily take a look.

[learningtoexcel]

Thanks for the reply and your willingness to assist. Since my original post I have figured out a way to accomplish a few more of my goals. I will add the updated worksheet to this post so you can take a look.

Here are some of the additional things that I'm looking to do:

1. For the Sale Entry, Inventory Purchase Entry, and Fun Money withdrawal entry, I would like them logged to another sheet in their own separate columns with the corresponding entry date. This will be for reference as time progresses
2. Currently, I have a mix between Excel functions and macros in the worksheet. Would it be more wise to use all formulas within the macros instead? You will see what I mean when you look at the worksheet.
3. I want to put a yes/no (Are you sure you want to reset?) condition on the reset button as an added level of security
4. I would also like to put a condition in the input boxes that if I choose to cancel the entry instead of put in a number it closes the box instead of giving me a debug error message.

Thanks so much for taking a look! Let me know if you need me to clarify anything