| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Data Grid - Changing Column Width
Could anyone let me know either of 2 things:
1) How do you change the column width of a data grid? 2) Is it possible to autofit the columns? I am using Microsoft Data Grid Control v6.0 Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Data Grid - Changing Column Width
With DataGrid1
.Columns(0).Width = 0 .Columns(1).Width = 3000 .Columns(2).Width = 1030 End With don't see any evidence that it supports autofit. -- Regards, Tom Ogilvy "ecm1185" wrote in message ps.com... Could anyone let me know either of 2 things: 1) How do you change the column width of a data grid? 2) Is it possible to autofit the columns? I am using Microsoft Data Grid Control v6.0 Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Data Grid - Changing Column Width
Thanks for your help. As a follow up, is it possible to delete one of
the rows? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA Data Grid - Changing Column Width
once you put the control on your userform, then look in the object browser
and study the methods and properties available for the control and its objects. -- Regards, Tom Ogilvy "ecm1185" wrote: Thanks for your help. As a follow up, is it possible to delete one of the rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Row Height/Column Width | Excel Discussion (Misc queries) | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| Changing column width for opening *.csv in Excel | Setting up and Configuration of Excel | |||
| Locking Column Width when changing Data in a Pivot Table | Excel Discussion (Misc queries) | |||
| Can I make column width and row height equal (a grid) in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
