Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Aug 2009
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    I'm having a 'moment' and can't locate where I can find the vb code 'key', i.e. what I need to use to make the text all bold, on the next line, a certain size etc etc....

    Can someone point me in the right direction......as I'm lost!

    Thanks everso!

    Penny

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Penny,

    The macro recorder is your friend.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Lounger
    Join Date
    Aug 2009
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Paul

    Thanks for your reply......before I look at downloading the Macro Recorder, I have seen whilst working on this project a list of 'codes' that you can use whilst writing code, i.e. if you prefix text with '&20' it will make that text font size 20.......its the list of these 'little codes' that I'm looking for...I've seen them before but I can't find them now

    Do you have any ideas as to where I could find these? Or alternatively, I've posted a different post which is more specific with regards to what I'm looking to do. I've also included the code I've written so far to see if anyone can amend it to do what I want it to do.........eek! I'm so far out of my depth it's silly!

    Many thanks.

    Penny

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Penny,

    You don't download the Macro Recorder - it's built into Excel - Tools|Macro|Record New Macro!
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Please continue the discussion in the topic VB Code to make text blue and on two lines please???

Posting Permissions

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