Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm setting up a spreadsheet that needs to run on PC's and Mac's. This means
I cannot use ActiveX ctrls. An ActiveX control allows you to use multiple columns; a Forms Listbox doesn't. I get around this by concatenate columns. However, I would like the Listbox to look neat. When I concatenate the columns I put in the right amount of spaces to flush the first part of the new column left and flush right the right portion of the column, but ONLY if it's Courier (monospaced font). However, the text formatting doesn't carry over to my listbox. I would like to change the font of my Listbox - is there a way to do it (either by programming or otherwise)? Thanks for any help . . . Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=EMBED("Forms.TextBox.1","") | Excel Discussion (Misc queries) | |||
=EMBED("Forms.CheckBox.1","") | Excel Programming | |||
Diff. change headline in "Formatting" or "Outlining" toolbar? | Excel Discussion (Misc queries) | |||
what does =EMBED("Forms.ComboBox.1","") mean? | Excel Programming | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming |