topic Re: in VBA Forum

Help with List Box Headings

Anonymous — Thu, 06 Jan 2000 16:06:11 GMT

Could someone please help?

I have a list box with 4 columns and the headings property set to true.
When I run my program, the headings show up but are empty.
I would like the put some heading titles and cant figure out how.

The help for this process is of little help and reads:
When the system uses the first row of data items as column headings, they
can't be selected.
I can't figure out how to use the first row of data items as column
headings.

Thanks in advance,
Jeff

Re: Help with List Box Headings

Anonymous — Thu, 06 Jan 2000 16:21:20 GMT

A list box or a grid?

"Jeff" wrote in message
news:852f21$9o325@adesknews2.autodesk.com...
> Could someone please help?
>
> I have a list box with 4 columns and the headings property set to true.
> When I run my program, the headings show up but are empty.
> I would like the put some heading titles and cant figure out how.
>
> The help for this process is of little help and reads:
> When the system uses the first row of data items as column headings, they
> can't be selected.
> I can't figure out how to use the first row of data items as column
> headings.
>
> Thanks in advance,
> Jeff
>
>

Re:

Anonymous — Thu, 06 Jan 2000 16:23:05 GMT

Thanks for responding Frank,

It's a list box.

Thanks
Jeff

Frank Oquendo wrote in message <852fl7$9o326@adesknews2.autodesk.com>...
>A list box or a grid?

Re:

Anonymous — Thu, 06 Jan 2000 18:59:52 GMT

Jeff,
Check out the help files for the textcolumn property. I think that's
what your looking for.
-Josh

Jeff wrote:

> Thanks for responding Frank,
>
> It's a list box.
>
> Thanks
> Jeff
>
> Frank Oquendo wrote in message <852fl7$9o326@adesknews2.autodesk.com>...
> >A list box or a grid?

Re: Help with List Box Headings

Anonymous — Thu, 06 Jan 2000 21:58:02 GMT

You may be misunderstanding the use of columns in a list box. Columns cause
a list box to scroll horizontally as opposed to vertically. If you want
columns that you can enter specific items into (like a record in a
database), use a grid instead.

"Jeff" wrote in message
news:8532so$bq449@adesknews2.autodesk.com...
> Josh,
>
> Thanks for the help, but the textcolumn sets the active column to read
from.
> I want to give the headings a name.
>
> Thanks
> Jeff
>
> Minkwitz Design wrote in message <3874E628.AFA64232@xta.com>...
> >Jeff,
> > Check out the help files for the textcolumn property. I think that's
> >what your looking for.
> >-Josh
> >
>
>
>

Re:

Anonymous — Thu, 06 Jan 2000 21:58:36 GMT

Josh,

Thanks for the help, but the textcolumn sets the active column to read from.
I want to give the headings a name.

Thanks
Jeff

Minkwitz Design wrote in message <3874E628.AFA64232@xta.com>...
>Jeff,
> Check out the help files for the textcolumn property. I think that's
>what your looking for.
>-Josh
>

Re:

Anonymous — Thu, 06 Jan 2000 22:22:55 GMT

Frank,

Thanks again!
You may be right that I am misunderstanding the use of columns.
I'm not sure how to use a grid control. I didn't think there is one.
I'm new to programming with vba.

Here is a sample of the code I'm using:

Private Sub UserForm_Initialize()
ListBox1.ColumnCount = 3
ListBox1.ColumnHeads = True

ListBox1.AddItem "Row 1, Col 1"
ListBox1.List(0, 1) = "Row 1, Col 2"
ListBox1.List(0, 2) = "Row 1, Col 3"

ListBox1.AddItem "Row 2, Col 1"
ListBox1.List(1, 1) = "Row 2, Col 2"
ListBox1.List(1, 2) = "Row 2, Col 3"

ListBox1.AddItem "Row 3, Col 1"
ListBox1.List(2, 1) = "Row 3, Col 2"
ListBox1.List(2, 2) = "Row 3, Col 3"

End Sub

Frank Oquendo wrote in message <8533ci$dr91@adesknews2.autodesk.com>...
>You may be misunderstanding the use of columns in a list box. Columns cause
>a list box to scroll horizontally as opposed to vertically. If you want
>columns that you can enter specific items into (like a record in a
>database), use a grid instead.
>

Re:

Anonymous — Thu, 06 Jan 2000 22:33:43 GMT

I must have missed the VBA part. You are correct, there is no grid available
in stock VBA.

"Jeff" wrote in message
news:8534ab$drd5@adesknews2.autodesk.com...
> Frank,
>
> Thanks again!
> You may be right that I am misunderstanding the use of columns.
> I'm not sure how to use a grid control. I didn't think there is one.
> I'm new to programming with vba.
>
> Here is a sample of the code I'm using:
>
> Private Sub UserForm_Initialize()
> ListBox1.ColumnCount = 3
> ListBox1.ColumnHeads = True
>
> ListBox1.AddItem "Row 1, Col 1"
> ListBox1.List(0, 1) = "Row 1, Col 2"
> ListBox1.List(0, 2) = "Row 1, Col 3"
>
> ListBox1.AddItem "Row 2, Col 1"
> ListBox1.List(1, 1) = "Row 2, Col 2"
> ListBox1.List(1, 2) = "Row 2, Col 3"
>
> ListBox1.AddItem "Row 3, Col 1"
> ListBox1.List(2, 1) = "Row 3, Col 2"
> ListBox1.List(2, 2) = "Row 3, Col 3"
>
>
> End Sub
>
>
> Frank Oquendo wrote in message <8533ci$dr91@adesknews2.autodesk.com>...
> >You may be misunderstanding the use of columns in a list box. Columns
cause
> >a list box to scroll horizontally as opposed to vertically. If you want
> >columns that you can enter specific items into (like a record in a
> >database), use a grid instead.
> >
>
>
>

Re:

Anonymous — Thu, 06 Jan 2000 22:58:23 GMT

Jeff - Have yuo considered using a LISTVIEW in report mode instead?

Jeff wrote:
>
> Frank,
>
> Thanks again!
> You may be right that I am misunderstanding the use of columns.
> I'm not sure how to use a grid control. I didn't think there is one.
> I'm new to programming with vba.
>
> Here is a sample of the code I'm using:
>
> Private Sub UserForm_Initialize()
> ListBox1.ColumnCount = 3
> ListBox1.ColumnHeads = True
>
> ListBox1.AddItem "Row 1, Col 1"
> ListBox1.List(0, 1) = "Row 1, Col 2"
> ListBox1.List(0, 2) = "Row 1, Col 3"
>
> ListBox1.AddItem "Row 2, Col 1"
> ListBox1.List(1, 1) = "Row 2, Col 2"
> ListBox1.List(1, 2) = "Row 2, Col 3"
>
> ListBox1.AddItem "Row 3, Col 1"
> ListBox1.List(2, 1) = "Row 3, Col 2"
> ListBox1.List(2, 2) = "Row 3, Col 3"
>
> End Sub
>
> Frank Oquendo wrote in message <8533ci$dr91@adesknews2.autodesk.com>...
> >You may be misunderstanding the use of columns in a list box. Columns cause
> >a list box to scroll horizontally as opposed to vertically. If you want
> >columns that you can enter specific items into (like a record in a
> >database), use a grid instead.
> >

--
/*********************************************************/
/* Tony Tanzillo Design Automation Consulting */
/* Programming & Customization for AutoCAD & Compatibles */
/* ----------------------------------------------------- */
/* tony.tanzillo@worldnet.att.net */
/* http://ourworld.compuserve.com/homepages/tonyt */
/*********************************************************/

Re:

Anonymous — Fri, 07 Jan 2000 12:43:27 GMT

Tony,

I don't understand you mean.

Thanks for the help,
Jeff

Tony Tanzillo wrote in message <38751E0F.79A41900@worldnet.att.net>...
>Jeff - Have yuo considered using a LISTVIEW in report mode instead?
>
>Jeff wrote:
>>
>> Frank,
>>
>> Thanks again!
>> You may be right that I am misunderstanding the use of columns.
>> I'm not sure how to use a grid control. I didn't think there is one.
>> I'm new to programming with vba.
>>
>> Here is a sample of the code I'm using:
>>
>> Private Sub UserForm_Initialize()
>> ListBox1.ColumnCount = 3
>> ListBox1.ColumnHeads = True
>>
>> ListBox1.AddItem "Row 1, Col 1"
>> ListBox1.List(0, 1) = "Row 1, Col 2"
>> ListBox1.List(0, 2) = "Row 1, Col 3"
>>
>> ListBox1.AddItem "Row 2, Col 1"
>> ListBox1.List(1, 1) = "Row 2, Col 2"
>> ListBox1.List(1, 2) = "Row 2, Col 3"
>>
>> ListBox1.AddItem "Row 3, Col 1"
>> ListBox1.List(2, 1) = "Row 3, Col 2"
>> ListBox1.List(2, 2) = "Row 3, Col 3"
>>
>> End Sub
>>

Re:

Anonymous — Fri, 07 Jan 2000 15:46:15 GMT

He's referring to yet another control that is not present in the VBA
toolbox. Right click on your toolbox and select 'Additional Controls'. In
the resulting listbox, find and select the Microsoft Listview Control. Add
one to your form and use its properties to set up your columns. Refer to the
online help for more details

"Jeff" wrote in message
news:854mos$g4v3@adesknews2.autodesk.com...
> Tony,
>
> I don't understand you mean.
>
> Thanks for the help,
> Jeff

Re:

Anonymous — Sat, 08 Jan 2000 14:14:39 GMT

Frank,

Thank you very much for your help and patients. I think the Listview
Control is exactly what I need and more, Much more. With some of the other
properties of this control, I think I'll save several lines of code in other
areas of my program.

The one last question I have is how do you find help online for this item. I
looked at both Microsoft Visual Basic Site and Autodesk Web Site.

Thanks again,
Jeff

Frank Oquendo wrote in message <8551vj$g4s27@adesknews2.autodesk.com>...
>He's referring to yet another control that is not present in the VBA
>toolbox. Right click on your toolbox and select 'Additional Controls'. In
>the resulting listbox, find and select the Microsoft Listview Control. Add
>one to your form and use its properties to set up your columns. Refer to
the
>online help for more details
>

Re:

Anonymous — Sat, 08 Jan 2000 18:57:37 GMT

Typically, you can select the actual control on your UserForm and press F1.
Also, be sure to use the Object Explorer extensively. Press F2.

Jeff wrote in message
news:857gev$mt52@adesknews2.autodesk.com...
> Frank,
>
> Thank you very much for your help and patients. I think the Listview
> Control is exactly what I need and more, Much more. With some of the other
> properties of this control, I think I'll save several lines of code in
other
> areas of my program.
>
> The one last question I have is how do you find help online for this item.
I
> looked at both Microsoft Visual Basic Site and Autodesk Web Site.
>
> Thanks again,
> Jeff