Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
"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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
On 8 mei, 22:05, Steve wrote:
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. Only the characters shown on top of that website. Its indeed possible to select Turkish in the Regional and language options, but I want to use it on different computers and it will be used by other people too |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
Ok,
those characters only. How about my original idea, but used in a manner that'd allow you to select one of them at a time, by use of a simple macro code? First, which office version are you using? 97, 2000, XP, 2003, or 2007? Next, We need to find out what the code is for each of those specific characters. I've done some further digging and have found some articles that you might find helpful. http://office.microsoft.com/en-us/ex...036001033.aspx Chip Pearson has a helpful tool he's made. http://www.cpearson.com/excel/chars.htm Up front three of the characters can be easily accessed. alt+0231 will give you the c with the squiggly beneath it. alt+0246 will give you the o with the two dots above it. and alt+0252 will give you the u with the two dots above it. The g with the upside down round hat (breve) is outside the 255 characters accessible with the alt key, as is the block i with the dot on top. "Mucah!t" wrote: On 8 mei, 22:05, Steve wrote: 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. Only the characters shown on top of that website. Its indeed possible to select Turkish in the Regional and language options, but I want to use it on different computers and it will be used by other people too |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
On 9 mei, 00:54, Steve wrote:
Ok, those characters only. How about my original idea, but used in a manner that'd allow you to select one of them at a time, by use of a simple macro code? First, which office version are you using? 97, 2000, XP, 2003, or 2007? Next, We need to find out what the code is for each of those specific characters. I've done some further digging and have found some articles that you might find helpful.http://office.microsoft.com/en-us/ex...036001033.aspx Chip Pearson has a helpful tool he's made.http://www.cpearson.com/excel/chars.htm Up front three of the characters can be easily accessed. alt+0231 will give you the c with the squiggly beneath it. alt+0246 will give you the o with the two dots above it. and alt+0252 will give you the u with the two dots above it. The g with the upside down round hat (breve) is outside the 255 characters accessible with the alt key, as is the block i with the dot on top. "Mucah!t" wrote: On 8 mei, 22:05, Steve wrote: 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. Only the characters shown on top of that website. Its indeed possible to select Turkish in the Regional and language options, but I want to use it on different computers and it will be used by other people too I'm using Office 2007. Here's the link of the sheet I'm working on. http://cid-e7c6bf41aa4a9275.skydrive...orum/TR2-2.xls Thanks for all your help Steve |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a symbol
On May 9, 7:29*am, "Mucah!t" wrote:
On 9 mei, 00:54, Steve wrote: Ok, those characters only. How about my original idea, but used in a manner that'd allow you to select one of them at a time, by use of a simple macro code? First, which office version are you using? 97, 2000, XP, 2003, or 2007? Next, We need to find out what the code is for each of those specific characters. I've done some further digging and have found some articles that you might find helpful.http://office.microsoft.com/en-us/ex...036001033.aspx Chip Pearson has a helpful tool he's made.http://www.cpearson.com/excel/chars.htm Up front three of the characters can be easily accessed. alt+0231 will give you the c with the squiggly beneath it. alt+0246 will give you the o with the two dots above it. and alt+0252 will give you the u with the two dots above it. The g with the upside down round hat (breve) is outside the 255 characters accessible with the alt key, as is the block i with the dot on top. "Mucah!t" wrote: On 8 mei, 22:05, Steve wrote: 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. Only the characters shown on top of that website. Its indeed possible to select Turkish in the Regional and language options, but I want to use it on different computers and it will be used by other people too I'm using Office 2007. Here's the link of the sheet I'm working on.http://cid-e7c6bf41aa4a9275.skydrive.../Public/Forum/... Thanks for all your help Steve- Hide quoted text - - Show quoted text - Perhaps someone else who can help me with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting symbol | Excel Worksheet Functions | |||
Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
Automatically inserting a symbol when text is entered in the cell | Excel Discussion (Misc queries) | |||
Problem inserting delta symbol into Excel | Charts and Charting in Excel | |||
font size auto changing from 11 to 15.5 when inserting a symbol | Excel Discussion (Misc queries) |