On 8 mei, 18:15, Steve wrote:
If you want to insert the symbol in to the middle of the word, then use the
form I showed you, but as follows:
Let's say your word is MucaT (since your user name has an exclamation point,
I'll use that as my example)
*sub symbol()
activecell.formular1c1 = "Muca" & (&H0021) & "T"
'in this case, it will insert a ! character.
*end sub
what you'll then get is Muca!T as your output.
The & .... & placement determines WHERE the character/symbol is placed.
This will work for most everything-- I've used it in numerous cases, and
have even just tinkered/toyed with it to see what I can, and cannot do. So
far I've only had a handful of characters that I cannot use like this.
hth
Best.
Let me know.
"Mucah!t" wrote:
On 8 mei, 01:13, Steve wrote:
I just had to do something like this yesterday.
Hopefully, it'll work for you too.
First find the symbol in the character map for windows-- assuming you're
using windows.
Then, click on the symbol, and look at the bottom of the character map window.
There's usually some type, and name code to describe that symbol.
Then, you'll use the numbers of that symbol to input in your macro.
e.g.,
--------------------------
sub symbol()
activecell.formular1c1 = "your symbol is: " & (&H0398)
'in this case, it will insert a Greek Theta character.
end sub
--------------------------
Since I'm not familiar with turkish characters, I have no idea what their
code values are.
hth....
"Mucah!t" wrote:
Hi all, Does anyone know how I can create a macro that will insert a
symbol when a button is hit.
The following site shows what I mean. When a certain symbol doesn't
occur on your keyboard it can still be entered by hitting the
corresponding button
http://www.turkishdictionary.net/
Hi Steve, Thanks for your reply but it isn't actually what I am
looking for.
Your code inserts a symbol, but it isn't possible to insert it lets
say in the middle of a word.
Hello Steve, thanks for your reply.
I think I didn't make clear enough what I'm actually trying to
accomplish.
It's the same idea as in the webpage I mentioned before.
I want to use the macro for turkish words but as not all keyboards got
the special turkish characters I'd like them to be entered by means of
a button instead of inserting them manually, what is very time
consuming.