Active X combo box help

[alexdetrano]

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 normal combo box working, but it
is too large and ugly and obtrusive so I figured if I took my hand at
an activex box I could keep my sheet looking pretty. Any help would
be greatly appreciated.

Thank you,
Alexander

 

[Guest]

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

 

[alexdetrano]

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

Hi

I do not want the XP look, as I already have a box that looks like
that (i.e. with the big red x close button and the ability the move) I
want the kind where you go to view, control toolbox, and then click
combo box.

 

[David G]

Hi

I do not want the XP look, as I already have a box that looks like
that (i.e. with the big red x close button and the ability the move) I
want the kind where you go to view, control toolbox, and then click
combo box.

Whats the problem with just using the combo-box from the control
toolbox?

David

 

[alexdetrano]

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.

 

[David G]

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.

After you create the button (using the control toolbox), double
clicking the button (while in Design mode) will automatically create a
VBA event-handler for the Click action. You can get your macro to
execute from there.

Cheers,
David