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


"(E-Mail Removed)" 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 <H...@discussions.microsoft.com> 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
>
> "alexdetr...@gmail.com" 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, alexdetr...@gmail.com wrote:
> On Apr 24, 9:46 pm, Halim <H...@discussions.microsoft.com> 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
>
> > "alexdetr...@gmail.com" 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 <goot...@gmail.com> wrote:
> On Apr 26, 8:51 am, alexdetr...@gmail.com wrote:
>
>
>
> > On Apr 24, 9:46 pm, Halim <H...@discussions.microsoft.com> 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
>
> > > "alexdetr...@gmail.com" 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, alexdetr...@gmail.com wrote:
> On Apr 26, 3:34 pm, David G <goot...@gmail.com> wrote:
>
>
>
> > On Apr 26, 8:51 am, alexdetr...@gmail.com wrote:
>
> > > On Apr 24, 9:46 pm, Halim <H...@discussions.microsoft.com> 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
>
> > > > "alexdetr...@gmail.com" 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