+ Reply to Thread
Results 1 to 3 of 3

Cells & Characters

  1. #1
    Ren
    Guest

    Cells & Characters

    Happy New to all!

    I'm having a problem with the number of characters I can put in a cell.

    This is what is happenning.

    I merge a number of cells together and increase the height to create one
    giant cell, where I would like a paragragh to appear.

    The idea is someone will click on 1 of 7 command button and depending on
    which command button got click the paragraph goes into the giant cell.

    Some of these text are large in size and thus does not fit into my giant cell.

    I tried a textbox and I get the same problem.

    Thus anyone know how to increase the text size?

    HELP!!

    Thanks to all for your help.

    Cheers

    Ren

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    To test out my idea, I put 10 strings of varying lengths into cells C1 through C10.

    Try this and see if you can modify it to fit your needs.

    Sub testcode()

    For i = 1 To 10
    myString = Range("C" & i)
    Range("E1") = myString
    Columns("E:E").EntireColumn.AutoFit
    myleft = Range("E1").Left
    myright = Range("F1").Left
    delta = (myright - myleft)
    ' MsgBox delta
    Columns("E:E").ColumnWidth = 8
    myFontSize = Int(10 / delta * 250)

    With Range("C12")
    .Value = myString
    .Font.Size = myFontSize
    MsgBox myFontSize
    End With
    Next i


    - Pete

  3. #3
    Dave Peterson
    Guest

    Re: Cells & Characters

    Try adding some alt-enters to the text that goes into the merged cell (pepper
    with quite a few).

    You'll have to adjust that rowheight either manually or via code (but not
    autofit), though.

    Ren wrote:
    >
    > Happy New to all!
    >
    > I'm having a problem with the number of characters I can put in a cell.
    >
    > This is what is happenning.
    >
    > I merge a number of cells together and increase the height to create one
    > giant cell, where I would like a paragragh to appear.
    >
    > The idea is someone will click on 1 of 7 command button and depending on
    > which command button got click the paragraph goes into the giant cell.
    >
    > Some of these text are large in size and thus does not fit into my giant cell.
    >
    > I tried a textbox and I get the same problem.
    >
    > Thus anyone know how to increase the text size?
    >
    > HELP!!
    >
    > Thanks to all for your help.
    >
    > Cheers
    >
    > Ren


    --

    Dave Peterson

+ 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