Results 1 to 3 of 3

TextBox MultiLine and WordWrap

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2010
    Location
    Swindon, Wiltshire
    MS-Off Ver
    Excel 2003
    Posts
    30

    Question TextBox MultiLine and WordWrap

    I have some code to add textboxes to a miltipage userform. The boxes that hold the data to be entered need to have multiline and wordwrap as true. Can someone tell me where I can add the .MultiLine and .WordWrap switches into this code?

        ' Add the boxes for the data
        '###
        ' Need to set multiline and wordwrap for these boxes
        '###
        Set cCntrl = UserForm1.MultiPage1.Pages(PageNum).Controls.Add("Forms.TextBox.1", _
        "Data" & BoxNum, True)
        With cCntrl
            .Width = 150
            .Height = 36
            .Top = BoxTop
            .Left = 160
            .ZOrder (0)
            .Locked = False
        End With
        With cCntrl.Font
            .Name = "Arial"
            .Size = 10
        End With
    Last edited by BillWilts; 10-20-2010 at 02:37 PM.

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