+ Reply to Thread
Results 1 to 3 of 3

Userform... (¶) how to remove the paragraph symbol?

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    8

    Userform... (¶) how to remove the paragraph symbol?

    Hi, I keep getting this (¶) appearing on my userform in text boxes where the original cell has 2 lines,3lines or more of text. Is there a way of removing this?
    Last edited by ricku87; 01-22-2013 at 12:39 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Userform... (¶) how to remove the paragraph symbol?

    Hi, ricku87,

    change MultiLine for the Textbox from False to True which should display the contents like in the cell (maybe alter the height of the textbox as well).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Userform... (¶) how to remove the paragraph symbol?

    Thanks this has worked brilliantly!!!!

+ 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