Excel VBA Data Grid - Changing Column Width

E

ecm1185

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
 
T

Tom Ogilvy

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top