Simple Calculator

I would like to make a simple calculator in Excel2013 and I know there are many on the web but I want to make my own if possible to practice and configure it the way I want it

The attached sheet has a sample on what I practice. When I click for example on m (meter) cell and change its value say to 5, all cell above and below the 1m cell change however I want this to happen when I change the value in any cell, like if click on ft (feet) and type a new number there it should change the values in all cell

Is this something simple or very complicated to do?

Thanks so much for your time, I will print and review the attached sheet and come back with my comments.

I went to the Excel Convert Function page but I didn’t see any download button. Perhaps I will have to register first?

Much appreciated
Nicolas

I use simple conversion table.. instead of vba..

table is on same sheet as converter now but can also be on separate sheet out of sight.

I think it is possible to put it in a formula but am to tired to think it up

Thanks Roel, I dont see any table on the same sheet, perhaps I miss something?

Sorry I was looking at the wrong file, now I see the table

Is it possible to give me some explanations on the table?

Thanks

The table simply shows the conversions each column represents 1 unit so 1 mm and reading down you see how that 1mm is 0,1 cm etc..

The index and match match formula does nothing more than look up the conversion number for the chosen measurements. where the from unit is in columns and the to unit is in rows and where they cross eachother is the conversion multiplier. to get from a to b

Thank you Roel, I will study the table and see how it can help me

Thanks Roel for your help, I studied the .xlsx you sent me and it looks like what I want. I can make my own drop down list and I should be ok with the formulas but my question for now is:

What is the purpose of the list between columns B&C, rows 5-10? The formula does not change for each row so I just wonder.

Thanks

the formula in those ranges do change as row() gives a different number each line so the Hlookup looks up values in another columns The ROW() function trick can be helpfull if you need a different number on each row but dont want to type manually the number.

The formulas have no real purpose if you only want to show 1 chosen conversion. You can leave them out.

I also tinkered with the formulas a bit and was able to comeup with a simpeler lookup table. Because this formula converts every option to the smallest unit (mm) and then converts back to the chosen "to unit"

have a look at the new formula in the sheet with the new simplefied lookup table.

I will print both Vlookup/Hlookup formulas and study them to refresh my memory with all the parameters involved.

Is it possible to have the dropdown lists expended? Like instead clicking to select an item, all items are visible. Looks like they are locked?

For sure what you have shown looks like is what I want. I just try to better understand how the formulas work.

Much appreciated

I will study with my rusty experience the code and come back with the results. Hope all will be fine

Thanks for your time

Works very well now but when I add the “mass” code I get
For Length in both columns I get in
For mass I get in both columns g,kg,Ounces,Pounds,Stones,in

I think I can fix this problem myself tonight or tomorrow

Is there any way to change the font size when I view the Code? I use a laptop and I find the code reading king of difficult

Nicolas

I have been not successful to fix the problem with the “mass” code. When you have a chance let me know

Nicolas

Forgot to mention that I fixed the fonts inside the VBA Editor

I can see on the new download the code works well. Although I was careful perhaps I did something wrong so I will try again (Sunday I will have more time).

I will also follow your instructions to use the “Useful Code” you included with the download. No idea what’s for but guess I will find out

Nicolas

Sorry mehmetik I guess I did something wrong again but following your instructions for the “Useful Code” I get the message “Compile error, Invalid parameters” and I have a lot of red lines on the code.
Your instructions are (my questions on the right)::
1.Select the developer tab – Is this on a new Excel project?
2. Select view and then project explorer
3. Select your project – You mean the last file you sent me?
4. Select insert and then module
5. Paste this code in the module that opens and close it.
6. Select the developer tab
7. Select Macros – I see no Macros there, the list is empty
8. Select Test and then run
9. Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it. –But I did this on step 5 above

I attach the Excel I did the above

Nicolas

Your last post is #19 and regarding the problem you say you didn’t see any and I replied and said you are correct. Then you have a file attached which I opened and you have this “Useful Code” inside that file with instructions of what to do to install that code.

On the last file you sent me there is a tab before Sheet1 called (Useful Code). Is this code for me to install?

On Sheet1 of the same file I see the code

Now I understand, I thought the Useful Code was something I could incorporate into the Sheet1 code.

The Sheet1 code is all I need to keep going ahead with my small project. I will try to add more cases for other conversion units and hopefully all will be fine.

If I stumble I will come back here to ask for your excellent help and patience or perhaps I should start a new thread?.

I don’t know if it’s right or not but I will mark this thread as solved since for now my current questions have been answered

Nicolas

Originally Posted by mehmetcik

You misunderstood.

Look at My Post #21.

To see the code, right click on the sheetname at the bottom of excel and select view code.

I have done some additions to your code but now if I enter 1 to change any unit my 1 becomes 0.01 and all results are wrong.
This happened after I added the conversions to the case “Area”. Perhaps because there are so many zeros in the "Area" case?
Please see the attached

Nicolas

Unfortunately I get the same results again, when I enter 1 I get 0.01 and all conversions are wrong as per attached.

Nicolas

Originally Posted by MarvinP

Hi oskar,

There is already a calculator and Conversion tool that you can buy the code for. See PUP7 and buy the code. It is one of my favorite add-ins and the code is excellent.
http://spreadsheetpage.com/index.php/pupv7/home

Thanks Marvin for the tip but this utility is much more than I need and at US$60 (including the code) it’s pretty costly however for someone who can use all its features it may worth the money.
I only need the calculator and even that I do it as a hobby, really I don’t have much use for it.

Originally Posted by mehmetcik

Please Login or Register  to view this content.

I just discovered that if I input my value as 1.0 instead as 1 the code works.

Nicolas

Originally Posted by Roel Jongman

I use simple conversion table.. instead of vba..

table is on same sheet as converter now but can also be on separate sheet out of sight.

I think it is possible to put it in a formula but am to tired to think it up

Hi Roel

I try to make a simple interface like the attached picture where I can click in the left column to select one of the available units and by clicking let’s say on the Length it is reading from Sheet1 or wherever the Length formulas and tables are located.

But when I put in front of the formula Sheet1! it does not work, it says #N/A

If it’s possible / easy to do it, please let me know

Thanks