Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fix Column width in spreadsheet control?!
I finally got data showing on my userform with a spreadsheet control!
Now the only thing I need to do is to figure out how to fix the columns widths in the control to autofit. I'd appreciate any help. Thanks, Toiny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fix Column width in spreadsheet control?!
I believe the default for ColumnWidths in the ListBox and the ComboBox is
for autofit, which will set the column width to the longest string in the column, up to 72 points. If you want more spacing between columns then you will have to set the width of the columns a little wider than the autofit. You can set the ColumnWidths in the properties window while in the VB editor, or using code per VBA help file under "ColumnWidths". Note the "s", which differentiates between the worksheet ColumnWidth. "Webtechie" wrote in message ... I finally got data showing on my userform with a spreadsheet control! Now the only thing I need to do is to figure out how to fix the columns widths in the control to autofit. I'd appreciate any help. Thanks, Toiny |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fix Column width in spreadsheet control?!
I prefer the combination of backups and recovery services, have you ever heard about the service of <a href="http://www.recoverytoolbox.com/microsoft_sql_server_database_recovery_download.ht ml"sql server 2005 in recovery</a, provided by Recovery Toolbox for SQL Server? Indeed, it is not possible to write a separate article for all database-related issues
--- frmsrcurl: http://msgroups.net/microsoft.public...dsheet-control |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column width of the default start-up spreadsheet? | Setting up and Configuration of Excel | |||
how to export a spreadsheet with column width over 255 maximum excelallows? | Excel Discussion (Misc queries) | |||
Spreadsheet column width from html | Excel Discussion (Misc queries) | |||
Spreadsheet column width from html | Excel Programming | |||
Create a macro which takes a column name and width and sets the column width to what it should be | Excel Programming |