![]() |
|
|
|
#1
|
||||
|
||||
|
I don't know how to correctly handle the minus sign (is b-a the same as a-b in hebrew LTR and english RTL) or the spaces but this should be enough to get you started Code:
Sub MyCalculator()
Dim aChar As Variant, aRng As Range, iTotal As Long
Set aRng = Selection.Range
For Each aChar In aRng.Characters
Select Case AscW(aChar)
Case 1488 To 1497: iTotal = iTotal + AscW(aChar) - 1487
Case 1499: iTotal = iTotal + 20
Case 1500: iTotal = iTotal + 30
Case 1502: iTotal = iTotal + 40
Case 1504: iTotal = iTotal + 50
Case 1505: iTotal = iTotal + 60
Case 1506: iTotal = iTotal + 70
Case 1508: iTotal = iTotal + 80
Case 1510: iTotal = iTotal + 90
Case 1511: iTotal = iTotal + 100
Case 1512: iTotal = iTotal + 200
Case 1513: iTotal = iTotal + 300
Case 1514: iTotal = iTotal + 400
Case 45: iTotal = iTotal * -1 'a minus sign
End Select
Next aChar
MsgBox iTotal
End Sub
Code:
Sub GetAscWFromLegend()
Dim arr() As String, i As Integer, aRng As Range
Set aRng = Selection.Range
arr = Split(aRng.Text, " ")
For i = LBound(arr) To UBound(arr)
Debug.Print AscW(arr(i)), Mid(arr(i), 3)
Next i
End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
#2
|
|||
|
|||
|
Thank you so much Andrew. Great help.
I forgot 5 letters that come at the end of a word. I will try to add them. ך=20 ם=40 ן=50 ף=80 ץ=90 |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Draft - Retirement Calculator | DJ0691 | Excel | 0 | 01-16-2020 06:56 AM |
Calculator in word
|
Zhibek | Word | 2 | 08-17-2018 12:07 AM |
Result Calculator
|
Raza | Excel Programming | 7 | 01-26-2015 11:35 PM |
| Excel Calculator | Mandusin | Excel | 6 | 12-25-2010 07:34 AM |
| Age Calculator in MS Outlook 2002 SP3 | turns | Outlook | 0 | 06-15-2010 12:26 AM |