+ Reply to Thread
Results 1 to 5 of 5

Textbox. Integral Height property doesn't do anything (worksheet control)

  1. #1
    Registered User
    Join Date
    06-16-2016
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    69

    Textbox. Integral Height property doesn't do anything (worksheet control)

    Hi,
    this isn't really a programming question but I guess it kind of fits here, I've added a textbox control (from the ActiveX group) on my worksheet. I've been playing around with the integral height property but it doesn't seem to be doing anythign at all. It won't resize the control regardless of whether lines are cut off or not. When I fooled around with the property for the Combo/List boxes, it worked (even though I had to set it to False first and then to True). With textboxes, no matter how many times I've changed it, it doesn't do anything at all. Am I doing something wrong or it simply doesn't work?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,140

    Re: Textbox. Integral Height property doesn't do anything (worksheet control)

    You should supply what you have tried.

  3. #3
    Registered User
    Join Date
    06-16-2016
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    69

    Re: Textbox. Integral Height property doesn't do anything (worksheet control)

    OK, it's rather simple really, I'm attaching the worksheet. As you can see the last line is cut off but changing the Integral Height property doesn't do anything to fix it.
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,140

    Re: Textbox. Integral Height property doesn't do anything (worksheet control)

    clear the text in the properties window, then type in the textbox, you will see the difference

  5. #5
    Registered User
    Join Date
    06-16-2016
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    69

    Re: Textbox. Integral Height property doesn't do anything (worksheet control)

    Quote Originally Posted by davesexcel View Post
    clear the text in the properties window, then type in the textbox, you will see the difference
    Didn't work, text is still cut off...
    Καταγραφή.JPG
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-18-2018, 01:49 PM
  2. Calendar Control Pop Up Set Height and Width
    By greatwent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2013, 01:25 PM
  3. [SOLVED] ActiveX TextBox Height
    By zplugger in forum Excel General
    Replies: 2
    Last Post: 01-17-2013, 10:00 AM
  4. run-time error '1004' unable to set the height property of the window class
    By xceldummy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2011, 06:39 PM
  5. Replies: 3
    Last Post: 06-14-2006, 02:10 PM
  6. vba problem with non writable chart height property
    By ppcm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2006, 02:20 PM
  7. [SOLVED] [SOLVED] Programatically control picture property of Image control
    By Brassman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2005, 05:06 PM
  8. Programatically control picture property of Image control
    By Brassman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2005, 10:11 AM

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