Hi, this is my first post to this forum but I've been really helped by the tips I've read from others in the past.
Unfortunately these have taken me into areas I'm unfamiliar with, and so I'd really appreciate some help.
learnt how to use Forms to give the user the ability to select an item from a List Box, I got frustrated because I couldn't
change the default font size (I'm designing a large file that is to be used on several machines with different screen
resolutions, and shrinking the sheet magnification down makes it very difficult to select an item).
discovered the Control Toolbox and painstakingly swapped all my Form toolbar List Boxes over to Control toolbar List
Two major problems resulted however. Firstly, I can't find any way to change the colour of individual items
in the list. In one of my forms I have over a hundred items in the list, just one of which must be selected by the user, and
I'd like individual items in the list to be one of a few different colours to make them easier to identify. Can this not be
done? If not, how else can you suggest I could make certain items in the list stand out?
Most annoyingly, every
time I move the mouse scroll wheel in a worksheet which contains a Toolbox-generated Form (usually just accidentally, it's
easily done), Excel promptly crashes. It's fine if I use the scrollbar in worksheets that don't contain forms, or that
contain forms that I created using the Forms toolbar however.
Apparently I'm not the first to find this, but is it
a known bug in Excel (I found the behaviour described at http://www.microsoft.com/communities...el.programming ) I've taken
mouse graphics acceleration or whatever it's called right off in case it was causing the problem, but without success.
I'd really appreciate suggestions for overcoming these problems - I thought the Toolbox type of forms were meant to
be what you should use for user selections, and that the Forms toolbar was just a legacy. But if I can't get Control toolbox
forms to work without crashing, what is the point of them, I'd be better off just sticking to using Forms, except they don't
work properly except at 100% magnification.
Incidentally, I've no idea how to go about programming in VBA, so I
hope you don't mind going easy with me if you tell me I need to start playing with Visual Basic codes, I'm a medical doctor
not a computer programmer! For the record I'm running Excel 2003 as part of Office 2003 Professional on a Windows XP
Professional Lenovo Thinkpad T60. Thanks in advance!