width

Hi, I have a worksheet that contains 119K lines and 150 columns. All the column headings are unique and the columns contain specific information and data about that particular product. Some products contain data from multiple columns. Eg below - Oil Seals - contains dimensional date in 4...

I'm trying to hide or turn off horizontal scroll bars in a listbox. It's a single column listbox holding one chrW(9660) and only needs to be about 20 wide. But the width must be 71 or more to not have a scroll bar. Any fix for this ? Thanks.

Hello, I want my users to fill excel where I have fixed column width and I dont want then to type longer text. So I want to color text in red for example if they exceed the column width. How can I do this? Thank you.

I have a couple of questions about the Listview control I can't find answers for . Can you hide or set width for 1st column ? It seems to be a special column, not one added by code. At the end of text is "..." even though the width is well within the column width. To remove them you have to...

PROBLEM I need to extract the Length and the Width (to do some calculations) of each product that comes through my system. ANALYSIS The data is held in one Excel cell and looks like this :- (various lengths of data) – L1111m, W222mm, T33um – (other various lengths data) or (various lengths of...

Hi - Please advise if this is possible If i know the screen size of my monitor - say my monitor is 20 x 11.3 (1920 x 1080 screen res) - is there a way i can have a formula in VBA that will give me the height and and width of the excel window if it was maximised? The reason why i ask is that i...

I'm looking at a way to resize an image placed into a cell so that it does not exceed the cell height or width whilst maintaining it's aspect ratio, in other words as soon as the height or width meets the cell width or height then it stops resizing. I've found this in another post which goes...

I'm am looking for something that I thought would be relatively easy. This is proving to not be the case for the amount of knowledge in VBA I have obtained. I would like a Plus and Minus icon on a spreadsheet and use these to increase/decrease a specific columns width. The key is I want to...

Hi forum, I'm new to this forum and relatively new to Excel and its functions. I have an Excel problem that I cannot solve easily by myself. I've tried googling and YouTubing without any progression. I work as a controller at a company in the Stone Industry and I have the responsibility to...

Hello! I have a userform that I want to be defaulted to a specific size, but when clicking an option button that has the value "Yes", I want the form to become wider. I tried: If ObYes.Value = True Then FrmCalc.Width = 732 but it doesn't do anything... Does anyone have an idea? Thanks! Julia

In my ongoing quest to optimize my laggy file, I've read that even if cells don't have overly complex formulas, repainting their contents (when calculations are running often, which is the case for me since I'm streaming in real-time stock data) is surprisingly resource-intensive. Simple Q: if...

Have a data set which results in column widths required to be set at a specific width. Is there a way to perform this task, the data can extend to many more than the example below. Auto fit does not work since the data in some cells may be larger. example Range("A1").ColumnWidth =...

Dear! I need help with excel. I have a mail database with approximately 5-10 columns and 100 - 50000 rows. I sort them by postal code. After that I give them autofits in height and width. I add one row at the beginning. Now i should somehow need all the colums in the first, empty, row filled...

Hi! So I have come across a problem which can be very annoying. If you have a frame that is say 400 height by 800 width and has vertical scrollbar enabled then within this frame is another frame at position top 1 and left 1 of that frame and is height 700 and width 700. Well since the height of...

Hello, I've tried a couple of things, but thought I'd ask online to see if its possible, or if there is an easier way of doing things. I'm trying to put a formulae/s together to get information from a price list. I've cut the list down as it actually goes up to 9.50m (901-950), but just so...

Can anyone tell me how i can lock my columns and rows so noone can change their width? When i give protect sheet and check all the boxes it still allows me to change the width it only stops me from entering data. Also is there a way to stop the message that the sheet is locked pop-up every...

Hello all, First time poster here. I am creating a comprehensive product analyzer for my company and I am stuck on one part of it. To preface this problem, I will give a little bit of background about the business to hopefully shed some light on the issue. We are an e-commerce company that...

I have a worksheet whereby I want column A to always remain hidden, yet at the same time, I want to allow users to be able to adjust the width of all other columns. Is that possible?

Hi, I am trying to do an array of column widths where specific columns are selected and for each column there is a different width but with no luck, is it actually possible to do this in an array?. Example Column B - width 10 Column D - width 19 Column G - width 16

Good Evening all. I have a formula I use and would like to make it a User Defined Function (UDF) I have replace the dell references with actual numbers for clarity. The worksheet formula is: =1/(SIN(RADIANS(DEGREES(ATAN(3/1)))))*12.5*20 The code I tried to write is: Function...