Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Hello All,
I am looking for a way to include a square root symbol that will display in a selected cell when the macro is activated. I've looked up the various ASCII codes (chr(10) is awesome) but have been unable to find the particular one for the Square Root symbol. If it is available through any other method, please advise and I will be exceptionally grateful. Chaz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
There isn't an ASCII Code for the Square Root symbol
You'd need a Maths Font for that On Thu, 25 Jan 2007 04:46:16 -0000, MentalDrow wrote: Hello All, I am looking for a way to include a square root symbol that will display in a selected cell when the macro is activated. I've looked up the various ASCII codes (chr(10) is awesome) but have been unable to find the particular one for the Square Root symbol. If it is available through any other method, please advise and I will be exceptionally grateful. Chaz -- Steve (3) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Hi,
Choose Insert, Symbol, and in the Arial font set you will find ˆš at 221a, way down the list. -- Cheers, Shane Devenshire "MentalDrow" wrote: Hello All, I am looking for a way to include a square root symbol that will display in a selected cell when the macro is activated. I've looked up the various ASCII codes (chr(10) is awesome) but have been unable to find the particular one for the Square Root symbol. If it is available through any other method, please advise and I will be exceptionally grateful. Chaz |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Maybe in Excel 2003+
No Insert Symbol in my 2000 What did you mean by 221a Steve On Thu, 25 Jan 2007 05:08:56 -0000, ShaneDevenshire wrote: Hi, Choose Insert, Symbol, and in the Arial font set you will find ˆš at 221a, way down the list. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Not sure if you wanted it as part of the macro you mentioned but if so here
it is Sub Radical() ActiveCell.NumberFormat = ChrW(8730) & "General" End Sub -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "MentalDrow" wrote: Hello All, I am looking for a way to include a square root symbol that will display in a selected cell when the macro is activated. I've looked up the various ASCII codes (chr(10) is awesome) but have been unable to find the particular one for the Square Root symbol. If it is available through any other method, please advise and I will be exceptionally grateful. Chaz |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
That works - but first I couldn't see anything :)
Needs a value in the cell So is this just a tweak of the "Currency" format ? Steve On Thu, 25 Jan 2007 07:11:01 -0000, John Bundy wrote: Not sure if you wanted it as part of the macro you mentioned but if so here it is Sub Radical() ActiveCell.NumberFormat = ChrW(8730) & "General" End Sub |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Wow,
Looking at the times I got my responses in I have to say "Don't you people ever sleep?!?" The answer is either "No" or you're in a completely different time zone. Hee hee. At any rate, thanks for the quick responses from everyone. It's nice to know we have e-communities like this where folks are willing to help each other out. John, you nailed the solution on the head. While the way you typed it out isn't 'exactly' what I needed, it pointed me in the right direction. I took what you gave me and applied in the manner below since I was working with a range I was merging rather than a singe cell: ActiveSheet.Range(("A" & FirstRow), ("J" & LastRow)).Select With Selection .NumberFormat = "General" .Merge .HorizontalAlignment = xlCenter .VerticalAlignment = xlTop .FormulaR1C1 = "S = " & chrw(8730) & ... This produced S = ˆš and the rest of the formula. In the merged cells, I'm showing the variables and the values the users input for the ones used to solve for "S". From there I display the formula with just the variables (not their values). The next line show's how the numbers replace the "empty" variables and finally the last line shows S = <value. I'm using this to develope a calculation sheet using various formulae to determine the minimum speed a vehicle was traveling based on evidence at an accident scene. Fun stuff but takes lots of patience. Thanks for all the help and thanks for being up at what non-shift workers would consider an "Ungodly" hour. Chaz "MentalDrow" wrote: Hello All, I am looking for a way to include a square root symbol that will display in a selected cell when the macro is activated. I've looked up the various ASCII codes (chr(10) is awesome) but have been unable to find the particular one for the Square Root symbol. If it is available through any other method, please advise and I will be exceptionally grateful. Chaz |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
Steve,
XP has it. But you can always use the good old character map program (which you may have to add as it is not added by default in the windows setup process). In there you can select the root character and then copy it and switch back to Excel and paste it. (From Windows Start Menu select All Programs | Accessories | System Tools and then select Character Map). -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "SteveW" wrote: Maybe in Excel 2003+ No Insert Symbol in my 2000 What did you mean by 221a Steve On Thu, 25 Jan 2007 05:08:56 -0000, ShaneDevenshire wrote: Hi, Choose Insert, Symbol, and in the Arial font set you will find ˆš at 221a, way down the list. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Square Root Symbol in VBA
I forgot about that - thanks
Steve On Thu, 25 Jan 2007 08:28:00 -0000, Martin Fishlock wrote: Steve, XP has it. But you can always use the good old character map program (which you may have to add as it is not added by default in the windows setup process). In there you can select the root character and then copy it and switch back to Excel and paste it. (From Windows Start Menu select All Programs | Accessories | System Tools and then select Character Map). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i use square root on excel - what is the formula | Excel Worksheet Functions | |||
Excel is changing the comma symbol in formulas to a square box ? | Excel Discussion (Misc queries) | |||
½ symbol prints a 2 and Winding square box prints a F | Excel Discussion (Misc queries) | |||
how do you calculate the 5th square root in MS Excel? | Excel Worksheet Functions | |||
Root mean square (RMS) error formula | Excel Worksheet Functions |