+ Reply to Thread
Results 1 to 1 of 1

Change of formatting in a sentence to subscript

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    640

    Change of formatting in a sentence to subscript

    I am creating a l;etter generator for a redress calculation in word rather than excel. The below piece of code is part of the breakdown table and I want the (1) in the "Selection.TypeText Text:="Interest(1) on (A) to date" to be in subscript (as it refers to legal wording at the bottom of the document) but the formatting keeps it Arial 11 and I cannot work out how to change it.

    Not sure it's the right forum but it's the only place I am joined up so thought I would throw it out there. I have tried find and replace but it didn't quite work

    Any assistance would be appreciated

    ' ########## Additional - Additional Interest (Tab 2) ##########
    
    Dim Additional As Currency
    If amountAdjust.Text <> "" Then
        RowCount = RowCount + 1
        CharCount = CharCount + 1
        AdditionalABC = "+" & Chr(CharCount)
        Additional = amountAdjust.Text
        Selection.TypeText Chr(CharCount)
        Selection.MoveRight Unit:=wdCell, Count:=1
        Selection.TypeText Text:="Interest(1) on (A) to date"
        Selection.MoveRight Unit:=wdCell, Count:=1
        Selection.TypeText Format(Additional, "Currency")
        Selection.MoveRight Unit:=wdCell, Count:=1
    End If
    Last edited by JBeaucaire; 06-30-2013 at 04:07 AM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1