Command button to toggle Celsius (°C) and Fahrenheit (°F) conversion

**Rocky2013** · 10-13-2012, 11:04 AM

I need a command button to toggle back and forward "Celsius (°C)" and "Fahrenheit (°F)", These text will show on the button opposite to corresponding values.
Example: If values are in °C, the command button should text "Fahrenheit (°F)"; for °F button should text "Celsius (°C)".
Once the switch back from Fahrenheit to Celsius, D1 will rename to Celsius (°C).

Below code is came from another post, I do not know to link.

Please Login or Register  to view this content.

Thanks

**zbor** · 10-13-2012, 11:09 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**zbor** · 10-13-2012, 11:10 AM

Is thsi what you want?

Please Login or Register  to view this content.

**yogananda.muthaiah** · 10-13-2012, 01:44 PM

Hi,

Can this be done at userform level like

Example : Celsius (°C) -54 to converts to 98 Fahrenheit (°F)

**zbor** · 10-13-2012, 01:46 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**Rocky2013** · 10-13-2012, 04:25 PM

I supposed to attach a xlsm file with code and values; I forgot, sorry.

VBA works. Instead of "convert" button, is that possible to show
"Convert to °C" on the button, if the temperature values are in Fahrenheit?

Click the "Convert to °C" button again then button will rename to "Convert to °F",
VBA will convert the Fahrenheit values to Celsius values.

I have seen this being done in dual language web site converting between English and French.
The text shows French, the button shows "English".

In my spread sheet, the heading in D1 will noy be shown in white text to hide. Then I use if function
to check D1, to enter "°C" or "°F" after the temperture values.

Thanks

**zbor** · 10-13-2012, 04:44 PM

I thought on that and I try to make it that way.
However, a VBA don't return me what I would expect.

I've used NBVC approach from here: http://www.excelforum.com/excel-gene...=1#post2245810

And I would expect to get button name.
But I get Button 2 instead. Or any other KIND OF shape and number.

Please Login or Register  to view this content.

**zbor** · 10-13-2012, 04:46 PM

Also I got this as result for other approaches:

Please Login or Register  to view this content.

I hope somebody has some other idea of where is going wrong.

**Rocky2013** · 10-13-2012, 05:29 PM

Thanks of your effort. I hope I do not make it very complicate.
I wish I have 5% of your knowledge in VBA. I am starting to learn
VBA. How these two codes ("Convert" and "shape_name" merge together?
The new button will replace the "Convert" button.

Thanks Again

**zbor** · 10-14-2012, 01:40 AM

First of all, what MsgBox return you as result when you click on Celsius button?
If result is "Button 2" no matter what's name of it, then this part won't work, so no use of it.