On Apr 26, 3:34 pm, David G wrote:
On Apr 26, 8:51 am, wrote:



On Apr 24, 9:46 pm, Halim wrote:

Hi,

Do you wish to use an XP look combobox?
I think your idea is right because MSForms class doesnt supply an XP look
controls
unless you use ActiveX controls... by using Xmlschemas manifest for Excel.exe
--

Regards,

Halim

" wrote:
Hi there

I'm trying to use an activex combobox to display a list of data and
have it so that when a user picks on one, say BASIC it updates a
certain range of cells (say B82:B86) with values that I have defined
in a macro called basic. If they pick INCREASED it will update those
same cells except with numbers a little higher, which I have defined
in a macro called increased. I got a normalcomboboxworking, but it
is too large and ugly and obtrusive so I figured if I took my hand at
an activexboxI could keep my sheet looking pretty. Any help would
be greatly appreciated.

Thank you,
Alexander

Hi

I do not want the XP look, as I already have aboxthat looks like
that (i.e. with the big redxclose button and the ability the move) I
want the kind where you go to view, control toolbox, and then click
combobox.

Whats the problem with just using thecombo-boxfrom the control
toolbox?

David

I want to use the one from the control tool box. I just don't know
how to get the code to drive it to do what I want to do, such as a
launch a macro when a certain case is clicked.