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

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 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

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 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.

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 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

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.

On Apr 26, 9:15 pm, wrote:
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.

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