CAD Software Forum

Packing Heat

Oh 2 more questions.

Whats the max number of columns a listbox can have? It seems to be 10, wouldn't allow me to fill 30.

How do I change the colour of the listbox scrollbars?

Forum: VBA, . NET & IRX
Topic: VBA textalign
Replies: 1
Views: 4666
Sat Feb 16, 2002 2:18 pm
Jump to post

Packing Heat

Cheers Scott

I found that I had the button in the wrong sheet.

ListCars.RowSource = ("A2:J58")

That works.

Forum: VBA, . NET & IRX
Topic: VBA Listbox...need help filling ColumnHeads
Replies: 4
Views: 8161
Fri Feb 15, 2002 8:05 am
Jump to post

Packing Heat

VBA textalign

Okay, thanks to Scott I got my columnheads working

I have this

ListCars.TextAlign = fmTextAlignCenter

But is there a way to align the first column left, but the remaining columns centered?

Forum: VBA, . NET & IRX
Topic: VBA textalign
Replies: 1
Views: 4666
Fri Feb 15, 2002 8:03 am
Jump to post

Packing Heat

Thanks for attempting, but

ListCars.ColumnHeads = True just tells it that you want to display columnheads. The trouble I'm having is putting data in said columnheads.

Forum: VBA, . NET & IRX
Topic: VBA Listbox...need help filling ColumnHeads
Replies: 4
Views: 8161
Thu Feb 14, 2002 1:16 pm
Jump to post

Packing Heat

VBA Listbox...need help filling ColumnHeads

Here's my code... ------------------- 'Variables declared in main module though Public Cars As Object Public Row As Integer Set Cars = Sheets("Data").Cells Public I as Integer Private Sub UserForm_Initialize() Row = 5 While Not IsEmpty(Cars(Row, 1)) ListCars.AddItem (Cars(Row, 1)) ListCars...

Forum: VBA, . NET & IRX
Topic: VBA Listbox...need help filling ColumnHeads
Replies: 4
Views: 8161
Thu Feb 14, 2002 12:18 pm
Jump to post

Search found 5 matches

Display posts from previous

Sort by

VBA textalign

VBA Listbox...need help filling ColumnHeads