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/

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/

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.

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.

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.

"Mucah!t" wrote:


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.


Ok, I think I'm seeing it now.
You're talking about the 6 characters above the search bar.

Please provide an example from you.
When I think of that website, I'm seeing that in webpage form.

You're trying to dynamically choose some character to input a turkish
character when working in excel, correct?

Let me ask this.

Have you gone in to your control panel, selected Regional and language
options, then select details, then on the settings tab select add (@ right),
and it will bring up an add input window. Then select the drop down, and
choose Turkish.
It's my understanding that it will add a whole group of Turkish characters--
essentially turning your keyboard in to a Turkish character keyboard.

let me know how that goes.

Something else that I just thought of.
How many characters are there that you want access to?
Are there only those showing on the top of that webpage? Or, are there more?

"Mucah!t" wrote:

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.