Listbox from "Forms" toolbar

[Rich W.]

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

 

[NOPIK]

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

So, on Mac MyForm.ListBox1.Font doesn't work?

 

[Rich W.]

I could create a form within VBA (in the VBA editor, click on
"Insert/UserForm"), then put a Listbox on it, then I could change the font.

But I'm figuring that ActiveX forms are created this way . . . My
understanding, is that to get things to work on both Mac and PC platforms, I
need to use the Excel interface and controls from the "Forms" toolbar, rather
than forms created within VBA.

Part of the big problem is that I've never worked on a Mac and I don't have
access to one with MS Office. I've been given a spreadsheet and asked to make
it work on a Mac. (Needless to say, the spreadsheet needs user input and that
comes in the form (no pun intended) of forms.

So, basically, I'll take an advice I can get about getting things to work on
both platforms.

Thanks again,

Rich