VBA: List Box Column Width Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 10 Column list box in which I want to Change/Hide the 3rd element
programatically (sometimes).

This is what I am try to do set the width of the third element to zero but I
don't know the correct syntax:

Me.lstContacts.ColumnCount = 10
me.lstContacts.ColumnWidth =
0.35";0.95";0";0.45";0.85";0.85";0.95";1.05";1.65";1.65"

How can I do this?

Thanks

Ross
 
How does this related to using FrontPage?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Agree not realted to FP

But you can just change it using
IF {some condition} THEN
me.lstContacts.ColumnWidth = 0.35";0.95";0";0.45";0.85";0.85";0.95";1.05";1.65";1.65"
ELSE
me.lstContacts.ColumnWidth = 0.35";0.95";1.00";0.45";0.85";0.85";0.95";1.05";1.65";1.65"
END IF
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| I have a 10 Column list box in which I want to Change/Hide the 3rd element
| programatically (sometimes).
|
| This is what I am try to do set the width of the third element to zero but I
| don't know the correct syntax:
|
| Me.lstContacts.ColumnCount = 10
| me.lstContacts.ColumnWidth =
| 0.35";0.95";0";0.45";0.85";0.85";0.95";1.05";1.65";1.65"
|
| How can I do this?
|
| Thanks
|
| Ross
|
|
 
Back
Top