Converting three calculators on a worksheet into one with a dropdown box

I have attached a copy of my calculator, which manipulates the figure depending on the data input in various cells.

The user inputs a number in D6, D10 & E10 or D14 & E14 depending on the situation.

C6:D7 for No Payments

Please Login or Register  to view this content.

C10, D10 & E10 for Credit on Account

Please Login or Register  to view this content.

C14, D14 & E14 for Debit on Account

Please Login or Register  to view this content.

I want to merge everything so that the user uses the same boxes for each scenario by choosing whether there are no payments, a credit on the account or a debit on the account from a dropdown box that should appear in B5 with those options.

This would dictate whether there were three headings or four and the formula/calculation/validation used as mentioned above.
If the user selected no payments, the headings would be Monthly Amount, Instalments and Total.
If the user selected credit on account, the headings would be Monthly Amount, Instalments, Credit and Total
If the user selected debit on account, the headings would be Monthly Amount, Instalments, Debit and Total

Can anyone please help me achieve this?

Thank you so much for your help in advance.

Thanks for your reply crimedog. Is it possible without using the other calculator? I want to keep the worksheet clean. Also, I'm getting the same results no matter what I choose from the dropdown and what figures I input, along with an error in the total cell referring to unrecognised text.

Hello Jete, thanks for your reply.

I opened the worksheet that you shared and it comes up with an error in the Total cell and says #NAME.

Also, the M column doesn't appear/disappear depending on the dropdown selection.

Thank you, that works better. I'll hope someone with VBA experience can help soon. In the mean time, can the dropdown options be kept to the same sheet and preferably the cell where the dropdown box appears or the one immediately underneath?

Thank you very much.

Is it possible for the text be moved to a row instead of a column? Why is it that if I remove the calculator on the left and try to move this version the text in the dropdown disappears?

Jete, thank you so much. That's exactly what I was looking for.

Can anyone please help me to figure out the VBA to make row E appear in the worksheet JeteMc just shared when "Credit on Account" or "Debit on Account" is selected from the dropdown and row E disappear if "No Payments" is selected (it also seems to be the default so when the worksheet opens row E should not display initially)?

Is there anyone who can help with the VBA to make column E disappear according to the selection from the dropdown box as described in my previous post?

After experimenting, I seem to have messed with something and now a whole range of cells are made invisible when "No Payments" is selected from the dropdown. Any idea why this is?

Hey Jete, I am hoping you can help me please. I also want to add further behaviours like this but this time dealing with some rows. I'm not sure how you created the dropdown list and I would like to add another?

I've been trying without success to move forward with this, if anyone could please fill me in that would be much appreciated. Thank you.

Can anyone help?

I'm hoping someone knows the answer please.

I have uploaded a slightly modified version to redact data. This should be used instead of the original for any response. Thank you.

Anyone, please?

Anyone, please?

Hoping today someone will notice this that knows how to help.

Now also posted to MrExcel: https://www.mrexcel.com/board/thread...n-box.1148769/

Anyone, please?

This is the file that you should use in relation to this thread.

Hello everyone!

I have attached a copy of my calculator, which manipulates the figure depending on the data input in various cells.

C4 & D4, D10, E10 & (depending on dropdown selection) F10, or C16, D16 & E16 (depending on the situation).

Please Login or Register  to view this content.

I want to merge everything so that the user uses the same boxes for each scenario by choosing whether there are no payments, a credit on the account or a debit on the account from a dropdown box that should appear in C10 with those options. This is mainly working.

This would dictate whether there were three headings or four and the formula/calculation/validation used as mentioned above.
If the user selected no payments, the headings would be Monthly Amount, Instalments and Total.
If the user selected credit on account, the headings would be Monthly Amount, Instalments, Credit and Total
If the user selected debit on account, the headings would be Monthly Amount, Instalments, Debit and Total

The options must be hardcoded, not referring to external cells. It's close to working, but not quite.

I am trying to avoid having extra cells and was looking for a hard coded solution as I said before. I've attached my spreadsheet so you can see my progress.

Mine works fairly well, except for three issues.

Problems:
The first is the way that the debit calculator resets itself to hide a row when "No Payments" is selected, particularly now that the Day & Discount calculator has been introduced. Using the reset buttons causes multiple columns to be hidden incorrectly instead of "Credit" in Cell F10.

The second is the way that the day and discount calculator doesn't hide the other options when a selection is made. I'm trying to replicate the same type of behavior used with the debit calculator for the column, but with the relevant rows instead (obviously now with the same flaw hiding lots of rows).

The dropdown arrow also seems to move to the second to last row when the option changes from "No Discount". I want it to stay put.

Thank you for your help.

https://www.excelforum.com/excel-pro...pdown-box.html
https://www.mrexcel.com/board/thread...wn-box.1148769
http://www.vbaexpress.com/forum/show...box-(hardcoded
https://www.excelguru.ca/forums/show...4952#post44952
https://www.ozgrid.com/forum/index.p...76#post1241076