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

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

Excel VBA Data Grid - Changing Column Width
 

Thanks for your help. As a follow up, is it possible to delete one of
the rows?

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?