Page 1 of 3 123 LastLast
Results 1 to 15 of 36
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Using Macros for inserting Symbols (Office 2003)

    I have XP SP2, Ofc 2003 SP1, IE 6.0 SP2
    I am learning Spanish, so I have a lot of use now for accented A,E,I,O & U in capitals. The small letters are no problem. I can create them with an alt key. But the capitals take a lot of time. Right now, I am creating a list of about 200 (not an exaggeration) words for study. Every single one of them contains an accented capital O. I prefer to make these lists in capitals because they are easier for me to read.
    Of course, I can insert the symbol by clicking on Insert>Symbol>etc., but that is time a consuming process. I thought maybe I could create a macro inserting this, but there were several problems.
    1) I couldn't find the usual box that stops a macro recording and Tools>Macro>Stop Recording was not available while I was in the middle of a word in a cell.
    2) I couldn't find a way to create a shortcut by using a function key. I never use those, so they are unused keys. As it is now, the "F-Lock" key does not engage when I logon, so presumably I have 2 full sets of Function keys available to me
    3) In Word 2003, I can get the accented capitals by using Ctrl+', Shift A, but this doesn't work in Excel 2003, whether I am using the Spanish keyboard or the English keyboard. It works with both in Word.

    I went on the MS office assistance center online, went through the training for macros, and didn't get anything that helped.
    It's true that I am not very 'swift' with macros, it seems. This is very confusing to me. I am new to XP, and new to Office 2003, and find no real help under 'Help'. English books are not available here, and it simply costs a fortune to ship anything into Costa Rica. So.... I would rather find my answers here, if possible. This is the second time I have faced such a list in my study and this one containing over 200 words with every single one of them containing an accented character!
    I'm drowning over here!
    Can anyone help?

    Thank you very much for any assistance,
    Julia Henson

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    You can not have a macro run while in edit mode so if you are entering into a cell you can't call a macro to add a symbol.

    You could use autocorrect. Add an autocorrect entry (Tools - autocorrect)
    Replace: O^ with <alt>0211
    Add for each item upper and lower case you desire
    The only problem is that excel limits its use in edit mode. It only replaces whole words so you would have to add a space then O^ then another space then after it was replaced remove the spaces.

    Alternately, you could just add something like: O^ to mean a

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    I agree with Steve and Rory that Autocorrect may be the best option. There is also "Symbolize®" by Chip Pearson, which you can find here (down the page a bit, in alpha order); for 2003 get the COM add-in version which is available in the text describing the add-in.
    -John ... I float in liquid gardens
    UTC -7±DS

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    Hi Julia,
    Have you tried using Autocorrect to do this? If, for example, you create an autocorrect entry to change O~ to
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    Thank you all so very much!
    The thing that works for me the best is the Alt+0211. I had tried that, but it shows up as 211, not 0211. I didn't know to add the zero in front. Now, I am all set with all the Capital characters!
    The AutoCorrect function would change every 'O' I put in to an accented one, which I wouldn't want most of the time. It's just that this particular list is working with 'i

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    You also need to be sure that Num Lock is turned on. Alt+0211 will not work if Num Lock is off.
    Legare Coleman

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Using add-ins (Office 2003)

    A word to you in particular, John:
    I know there are many add-ins which can be downloaded from WOW, and one of these days I will check the one you have given me.
    Add-ins scare me, actually.
    I'm afraid I'll get a virus, or they won't work properly on my computer or that I won't be able to figure them out or...
    Maybe one of these days when I get more sure of myself, I might try them out.

    Thank you for the input,
    Julia

  8. #8
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Num lock affects character symbols

    Yes, Legare,
    Thank you - good point. Because that is so important and also something that I would forget all the time, I had the computer technician set my computer up so that the Num Lock goes on automatically when I power up.

    Thank you,
    Julia

  9. #9
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    Thank you, Steve,
    That's a very important point, with which I was unfamiliar. No wonder it didn't work!
    But as you see by my previous replies, the Alt key + is my solution, and one that is perfectly fine!
    Thank goodness!

    Julia

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Using add-ins (Office 2003)

    I understand. However, Chip Pearson (along with a number of Excel MVPs who have developed utilities, including our very own Jan Karel Pieterse) have a lot at stake on their reputations, and make sure that their utility products are safe and thoroughly debugged.

    But if you want to take a risk and have some fun, you could play with the beta Header & Footer Manager Jan Karel is working on in <!post=this thread,411800>this thread<!/post>. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7±DS

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    The proposed autocorrect was to have the "O" with another symbol (eg I used "^"). This would not change all of them only the O^ combinations.

    Steve

  12. #12
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Using add-ins (Office 2003)

    That is really good to know, John, and I will keep that in mind. Of course, you are right! Hopefully one of these days I will feel more secure and try one!

    Thanks, Julia

  13. #13
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Costa Rica
    Posts
    235
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Using Macros for inserting Symbols (Office 2003)

    Thanks, Steve.
    Duh! I was really paying attention, huh?

    Julia

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using add-ins (Office 2003)

    The sources John has mentioned can be trusted (in general). Speaking for myself: My addins NEVER contain viruses, I have an up to date scanner installed and working.

    As for bugs, well, that is another story of course. I try my very best to test my utilities thouroughly before releasing them, but that can not be a guarantee nothing might go wrong. There are just too many different users doing different things with Excel that may affect the working of my utilities in some way.

    But mostly they are secure enough and should something go wrong, one usually doesn't loose data.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Macros for inserting Symbols (Office 200

    For the / accent, there is a very simple pre-exisitng keyboard shortcut that often gets forgotten. For ANY vowel (upper case or lower case) pressing the Right Alt key (a.k.a. Alt Gr - immediately to the right of the space bar) will add the / accent:
    Grüße

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •