autosize

I have a textbox on a worksheet that I want to autosize, but ONLY vertically. I see in its properties the option for AutoSize, but this will adjust the box both horizontally and vertically. How can I lock its width?

I'm now using MS Excel 2016 on a MacBook Pro running macOS 10.12.6 (High Sierra) and the following code which worked well in MS Excel 2011 generates the error below in MS Excel 2016 and I'm unable to resolve the issue! Dim Commnt As Comment For Each Commnt In Application.ActiveSheet.Comments '...

Hi Everyone, I have a userform with a gallery of images in thumbnail size. I am trying to use a second userform that will resize to the size of the image. With the autosize property set to true the image displays at its original size. However, when i set the userforms width and height to the...

I'm attempting to format text into a List control, to match how it's handled when a label is set to Autosize and Wordwrap On. I've got a theory, using the label as template and List.AddItem for each line that fits. Then removing that from the source string and repeating until finished. To...

I am using Excel 2010 and have created a new default workbook, Book.xlts, and saved it in the XLSTART folder. A Ctrl-N will create a new workbook in the open Excel window based on this default workbook, but it retains its original size. I would like this window to open as the standard...

I have a worksheet called "Selected LP List" and on that worksheet, there are index(match()) functions in columns A:F that returns text linked to another worksheet. The problem I am having is that the rows do not automatically adjust the height so any wrapped text is cut off. Typically, column F...

Hi, I add comment in tooltip for a shape with hyperlink. The size of the tolltip is fixed an unfortunatelly too small. How to set Autosize for this comment or set the real height ? Sub AddComm() Dim Sh As Shape Dim txt As String Dim i As Integer On Error Resume Next...

Hello forum, I read many posts on this subject. I put together the following code and have a worksheet in my Dropbox. C:\Users\EDWARD P AYERS\Dropbox file name is TEXT MERGE RESIZE This code is not perfect; it does adjust with different column widths and font sizes. It uses formulas on Sheet1...