Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 772
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i use square root on excel - what is the formula Karen Excel Worksheet Functions 4 January 1st 07 12:15 PM
Excel is changing the comma symbol in formulas to a square box ? thesillyscot Excel Discussion (Misc queries) 2 September 13th 06 02:11 PM
½ symbol prints a 2 and Winding square box prints a F frank-e Excel Discussion (Misc queries) 2 March 22nd 06 11:03 PM
how do you calculate the 5th square root in MS Excel? Secrd Excel Worksheet Functions 2 October 3rd 05 06:38 PM
Root mean square (RMS) error formula Lea Olsen Excel Worksheet Functions 2 February 3rd 05 05:13 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"