Excel 2010 :: Combobox Column Widths Forces Points Instead Of Inches?

Jul 8, 2014

How the heck to work with comboboxes and listboxes.

In entering column widths, I want to do inches. I understand inches. I don't understand points.

The instructions say that it will take whatever is in the User Control Panel: Regional: Number settings. I checked. It is US system. Not points.

MSO 2010. Can I change it to inches or do I need to get used to points?

View 2 Replies


Change Border Widths Via Points

Mar 6, 2007

if it is possible to change the border thickness weight via points? Eg., "1/4 pt".

I find that the xlthin border prints too thick. The only way I've been able to reduce it to appearing thin when it prints is by choosing the second option under "None" in the Line Style option of the Format Cells dialog box.

While that approach prints a thin border, it is actually a dotted line and looks a bit odd on screen.

View 3 Replies View Related

Excel 2010 :: Worksheet Move / Copy Function And Paste Special / Columns Widths

Mar 18, 2014

I am trying to copy one worksheet using the "move/copy" function that is available when you right click a tab name and want to copy the worksheet in the same workbook

The steps I'm using are:

1. Right click the tab name
2. Select Move or Copy,
3. Select Create a Copy
4. Click OK

Doing all of the above does not work. When the new worksheet opens, all columns are the same width. It seems to be stuck on "autofit column width" setting of 8.5. The original worksheet is several columns wide all with different width settings.

I've also used Copy, Paste Special and selected column widths and that does not work either.

View 3 Replies View Related

Excel 2007 :: Column Widths Display Differently On Different Computers

Apr 11, 2013

Scenario: Two computers running Windows 7 (64-bit Professional) with Excel 2007, same processor, same hard drive, same memory, same everything except the monitors - see below

Computer 1: HP LA2006x monitor (20" viewable diagonal) @ 1600x900 resolution, 91.79 PPI
Computer 2: HP LA2206x monitor (21.5" viewable diagonal) @ 1920x1080 resolution, 102.46 PPI

We have an Excel spreadsheet that the column widths on columns A through K must equal exactly 6, 1, 6, 1, 8, 1, 13, 2, 8, 1, and 35 respectively in order for the data to be imported into another program. These exact column widths are set on Computer 1 and the .xslx file is saved to a network location.

Computer 2 opens the .xslx file from the exact same network location. The column widths display as 5.86, 0.92, 5.86, 0.92, 12.84; not the exact columns listed above. So if anyone needs to export the data from Computer 2, they have to manually adjust the column widths or run a macro to auto adjust the column widths.

My question, is there anything I can do on Computer 1 or Computer 2 to make it so the column widths are saved and open correctly no matter which one is saving and which one is opening? The 20" monitor on computer 1 cannot display the 1920x1080 resolution... already tried that.

View 3 Replies View Related

How To Setup Custom Paper Size Of 4 Inches By 6 Inches

May 1, 2012

How, using PageSetup and xlPaperSize properties, to setup a custom paper size of 4 inches by 6 inches???

View 3 Replies View Related

Excel 2010 :: Compile Error In Combobox Value?

Aug 11, 2014

I had a spreadsheet in 2007 with a drop down list of date. So that these showed as a date and not the numerical value I found and used the following.

[Code] .....

However I've now had a upgrade to 2010 and I get a compile error: Can't find project or library and the word Format is highlighted.

View 5 Replies View Related

Excel 2010 :: Combobox Event Error

Jul 10, 2013

Using Excel 2010. I have a ComboBox (Not ActiveX) on a worksheet

I'm trying to add an event so that when user click on a choice a macro is fired using the selected item as citeria for a filter When I click on the drop down and make a selection I receive this error msg:

Cannot find the macro "cboUserSelection_Change" The macro may not be available in this workbook or all macros may be disabled

I also tried _AfterUpdate - similar error message.

I added the Combo Box code to the Worksheet code, not a standard module

I was able to run a quick test macro so I do not believe "all macros are disabled"

View 1 Replies View Related

Excel 2010 :: Combobox Or Data Validation With Macro

Apr 9, 2013

I am using excel 2010. I have 3 separate form control each with its own macro. I would like to create a combo box with a drop down with a list of each form control case and be able to perform the same function as the individual form control when a specific name is chosen in the list of the combo box.

View 3 Replies View Related

Excel 2010 :: How To Auto Populate Data Based On ComboBox Selection

Jan 27, 2012

I have a question on how I could populate data using a combo box selection in Excel 2010.

For example, I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.

Maybe to make it clearer...

Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998

Combo box (selection of names): John

Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998

how I could solve this Also, do let me know if this can be done without the use of VBA.

View 4 Replies View Related

Excel 2010 :: Hide / Show Textboxes And Labels Based On Combobox Selection?

Jul 8, 2014

I have created a UserForm that has a ComboBox and depending on the number selected I want it to show that number of Labels/TextBoxes...

So if I select "0" nothing is shown, if I select "1" one set of Labels/TextBoxes is shown, select "2" and two sets of Labels/TextBoxes are shown... but also if I have selected "2" and then select "1" I want the second set to be hidden again...

Also I know I should have renamed the Label/TexBoxes to make it easer but I was adding things and making it up as I went along...

I'm using Excel 2010 on windows 7.

Sub UnHide_NewRoutings()
If (Engineering.ComboBox2.value) = "0" Then
Engineering.Label4.Visible = False
Engineering.TextBox5.Visible = False
Engineering.Label9.Visible = False
Engineering.TextBox9.Visible = False

[Code] ..........

View 3 Replies View Related

Adding Column Widths Of Merged Area To Match Single Column Width

Sep 19, 2012

I needed to match the width a merged area of seven columns to a single column width (for row autofitting). Adding the column unit values and setting the single column to that value produced a significantly narrower width.

The documentation mentions that the column width unit is scaled to the font type and size and the absolute width is given in points.

This is set by the normal style setting in Excel Options or by VBA application.standardfontsize = 8 (in this case).

For instance, ten columns of Arial font 8 at 8.5 units you would think to be equivalent to a single column of 85 units.
In points, the difference is 420 vs. 386.25, or 33.75 points.

Well, the standard character zero has a width at this setting of 4.5 points and 1 unit is 8.25 points, leaving 3.75 points for margins.

Then (10-1) margins allowances time 3.75 points resolves the difference.

Determining the margin allowances is straightforward, and reveals that the gradation with size is stepped by MS design.
For instance, sizes up to 11 use 3.75 points for margins and increasing points for characters (except between 9 & 10).
Sizes 12 through 18 use 5.25 points, 20 & 22 use 6.75, 24 & 26 use 8.25, etc.

I have created a table for this purpose, however I rarely use a "normal" other than 8, so I can probably use that set in programming.

View 1 Replies View Related

Adjust Multiple Column Widths In One Column On Button Click

Nov 19, 2006

I have a button for Column T that when clicked I would like to run through different column widths 25,35,45,55,65,75.

I've tried a case statement but it doesn't run through each case on the clicks.

View 9 Replies View Related

How To Get The Column Widths Value

Dec 20, 2006

I am doing a if else statement but I do not whats the keyword for getting the column width value


if column width value = xx

column width value = xxo

View 9 Replies View Related

Excel 2007 :: Formula For Decimal To Ft And Inches?

Mar 3, 2014

believe this is a simple formula I just cant seem to get it right. Example: H1 has 859.375 and I need H2 to be 71' 7 3/8

View 5 Replies View Related

Keep Formatting / Column Widths In The VBA?

Mar 17, 2014

This is doing ALMOST everything I need it to do. The only thing I need is for it to keep the formatting and column widths from the source sheet.


View 7 Replies View Related

Identify Column Widths In CM

Jan 23, 2010

how can know how is my column width in CM ,

View 9 Replies View Related

Listbox Column Widths

Apr 13, 2006

I have a 3 column listbox on a userform. I am trying to line the columns up with some label headers on the user form.

On thsi listbox, how can I code the first column to a width of 250, the second column to a width of 50 and the third column to a width of 75?

View 9 Replies View Related

Different Cell Widths In Same Column

Jul 27, 2007

I would like to know if it's possible to change width of different cells in a single column? Example:

Width of cell A1 would be 10, and width of cell A2 would be 15. Can it be done? If yes how, if no damn. The reason I ask is because I trying to fit a report on one page with a chart and a month worth of data, but some cells are to long and they get cut off.

View 3 Replies View Related

Set Multiple Column Widths

Feb 10, 2008

I've used the macro recorder to try to auto-apply column widths after I do a CSV import:

(A&B=3.14, C=8, D=13.57, E=24.14, F=9, G=10, H=11.29, I=8.57, J=6.86, K=8, L=13, M=10)

...but for some reason when I execute this macro, "every" column gets the width of 10!

how I can fix the below code?

Sub SetColumnWidth()
Selection.ColumnWidth = 3.14
Selection.ColumnWidth = 8
Selection.ColumnWidth = 13.57
Selection.ColumnWidth = 24.14

View 5 Replies View Related

Drop Down Forces Calculate

Oct 12, 2008

I am using a spreadsheet with a user defined function that contains an if and case statements fromthis thread. I am using a combo box to change the dependent cells but need something to automatically calculate the sheet. is there a way I can have a calculation occur every time a selection is made in the combo box or is there a macro that will do it.

View 6 Replies View Related

Return Column Widths Function

Nov 18, 2007

Suppose I have the following UDF, which returns the width of the column, but when the column width change (increase or decrease), the UDF is not able to recalculate the column width...what should I do? .....

View 9 Replies View Related

Listbox Column Widths And Lengths -Autofit

Dec 9, 2009

I've got a Listbox in a User form that looks at data on another spreadsheet purely for informational purposes, not to be selected. I have two problems with what it's doing:

1) There are 23 columns, of varying widths. However the listbox uses a standard width, so some items are truncated and some have too much room.

2) The data changes, and the number of rows may change from 2 to 15000. I've set the RowSource to cover the ranged from A1:W15000, but if only 2-300 lines are selected the user can't grab the scrollbar button to scroll through, but must instead use the arrow, which is rather slow.

Is there any way to set the column widths to match the data, and the Range to only go as far as the last populated row?

View 7 Replies View Related

Format Column Widths - Free And Fixed

Jan 11, 2010

I need to know how to format columns in a spreadsheet. What I want to do is autofit the columns, all except for Column A; I want that want at a fixed width of 9. The code below is my attempt to do this, and it's not resulting as I wish. Stepping through the code, it performs the first part beautifully and autofits all of the columns. Where I have the line

View 2 Replies View Related

Split Sheet So As To Have Independent Column Widths

Oct 3, 2007

For the past 4 months I have been desperate to find a way to split my sheet so that I can determine the column widths above and below that point independently.

For example:

small width from a1-b1
really large width from a2-b2

Is there a way to do that?

View 9 Replies View Related

Auto Size Column Widths For Printing

Jul 30, 2007

Need a bit of help with a dynamic column resize.

This is the scene. Imagine 2 lists of data, each list 2 columns wide (like 2 lists of names and phone numbers). List 1 covers column A and B, List 2 covers column D and E. I want it so that on the push of a button, columns A-E are automatically resized to be just big enough for their longest content, and column C resizes so that column D is on the next page.

The general idea is that you can print the sheet, and put together the pages relating to the seperate lists.

View 9 Replies View Related

Excel 2013 :: Two Identical Files Print At Different Widths?

Sep 23, 2013

I have a series of worksheets (different workbooks) that have the same exact column widths and line depths. On screen the width and depth is identical but when printed, one takes up less width and more depth and the other vice-versa. Most (over 100) are just fine but every once in a while another is found that is distorted in print preview and printing and there seems to be nothing I can do to correct the problem. One difficult solution is to take the content from the "wrong" worksheet, do a save as on a "right" worksheet and drop the content in there.

Office and Excel 2013Windows 8Saving as different versions (xls instead of xlsx) makes no difference.Same printerSame monitorsAll worksheets are set to 17 pixels for both columns and rows (looks like graph paper)After setting up print area and viewing, the light gray dashed lines that show page breaks are different! The majority ("right") sheets have four fewer columns and four more rows than do the "wrong" worksheets.

View 14 Replies View Related

Excel 2010 :: Count Distinct Text Values In One Column If Another Column Equals A Value

Mar 5, 2014

I am trying to count the distinct times a value shows up in a column, if another column has a 2 in it.

For example:
A, B

The results shoud be: (2) Because I only want to count the P25 one time.

I'm using Excel 2010

View 2 Replies View Related

Excel 2010 :: Calculating Sum Of Column By Column

Jul 2, 2014

I am making an order for my shop and I want to multiply product price X (Column #1) with quantity Y (Column #2) and sum it.

I have a picture attached : uznSuuc.png

I want it to be A2*B2+A3*B3+A4*B4+A5*B5+A6*B6+A7*B7=Z (Total)

BTW My office version is 2010.

View 12 Replies View Related

Excel 2010 :: How To Find First And Last Row And Last Column

May 5, 2012

I'm looking for one function for each of these properties that will provide them with negligible overhead in all or almost all spreadsheet data cases, such as the normal spreadsheets, autofiltered data, large workbooks, etc.

By the way, by "first row", I mean the first row after the header row, given that the header row is in row 1.

View 7 Replies View Related

Excel 2010 :: Sort Rows By Column

Sep 25, 2013

I am looking for some to create a simple macro to sort multiple rows in ascending order based on the values in a particular column in the selected range. I want to sort A4:AI1004 in ascending order by column D. I recorded the following macro in Excel 2010:


Sub sort()
' sort Macro
' sort by column D (Sequence #)
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select


First of all, I think this code can probably be simplified. Secondly, it does not work in older versions of Excel. In 2007 it always ends in a runtime error. How can I clean this up so that it will work in both versions of Excel?

View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved