I have an excel sheet that 6 columns have data validation, (drop down list), i want the width of the drop down list to expand when is selected
the following VBa code worked for me but is only for one column is there any way to do it for 6 columns
the VBA code is the following
Good day all
I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck.
I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...
Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ?
I have four column chart and the gap between series is big. I used the gap width button and the column width is increased overlap adjustment does nothing. Is there a way to bring the columns closer to each other?
I'm wanting to lookup a value from 2 separate cell values one being height and the other width - to find a match in a pricing matrix. If this can be done at all.
E.g - 717 x 448 = $36.06
Not sure if this is even possible, but I have a userform that has a width of 588 when fully viewed. What I'm wondering is when the user opens this I could have the width set at 150. And if in textbox2 they enter a 2 then the width of this frame will expand to 294. If the value entered in...
This my first post, apologies if I break any rules in the forum.
I am trying to use VBA to write a simple code to auto fit column width. I have data in columns A:Z and I have also merged cells D5:J5. Naturally, I think a simple line like the following will do the job...
I have an activex text box that I need to expand down as more text is entered. It is set to a width of 540 and when text reaches the edge, I want it to go to a new line and for the text box to grow one line larger. If it is deleted, I need it to shrink the text box to fit.
It must stay at the...
i have to extract numbers from a string in Col G (varying rows) the data looks like this
Width = 760, Depth = 350
Width = 1610, Height = 50, Depth = 16
Width = 1610, Depth = 350
my formula in col H
i need to be able to create an array of circles. for example, if cell A1 has the value 5 in it, and cell A2 has the value 600, then i need to be able to fit 5 circles in the width of 600... I hope i explained myself properly.
This is the most ridiculous that I have to ask but do any of you know how to get the hovering cursors back? Meaning the plus icon at the bottom of a cell, or the width arrows between columns!?! They disappeared and I don’t know where they went!!
I have a template of which i use for invoices.
I have made some alterations to the columns & what are in the cells but now my overall width is larger so when i preview it then you can see some is cut off etc.
I use the same template for another company of which this hasnt been altered...
I was wonder if there is a way to increase the width of a dropdown list.
I know that the width of the list is usually the same as the width of the column it is inbut I was wondering if it was possible to make it bigger all of the options are cut off.
I've tried to use this code but it...
When you double click on the line between 2 column Letters is automatically makes the column width fit the widest cell value. Is there a way to set excel or a work sheet to always automatically adjust the column width to the widest value?
I am trying to create a Macro that formats each column to a particular width. But, when I run the Macro, it just sets all the columns' width to 1. Where am I going wrong?
' Macro4 Macro
Selection.ColumnWidth = 1
I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are...
I am making a userform with checkboxes that will be a "Filter what you want to see" action. When you checkmark a checkbox it will then hide the designated column. When you uncheck it, it reverts back to unhide. My problem I have is it works great until you unhide the column and the...
I have written the following VBA. It works well when the input is within cell width. However, when the input is too long and exceeds the cell width (which some part of input will be hidden), the function seems not functioning properly.
Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target...
i have some code that is supposed to look at a specified sheet and figure out how many active rows it has and then look at column D and check each cell in that column to see if any are over 55. if any cell is over 55 it will give a message box as you can see... with this code it is giving...
Attached blank excel sheet column width is read in pixel 8.43 (64 pixel) top of column A I tried File menu --> Option --> Advanced --> Display Ruler to mm --> Press OK button
But that won't change pixel to mm
Am I missing something ? is this the...