Buttons

I want to place a button in or near a cell which allows the selection from a
menu of text items or computed answers. Must be simple but don't know where
to start looking.
Can someone help me out on this please?

STEVEN

Hi Steven,
And what would you want to do. Make an entry, call a macro.

Take a look at validation where you can get a list of valid entries.
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steven Young" <syoung@stevenyoung.co.nz> wrote in message news:dbh0af$p7p$1@lust.ihug.co.nz...
> I want to place a button in or near a cell which allows the selection from a
> menu of text items or computed answers. Must be simple but don't know where
> to start looking.
> Can someone help me out on this please?
>
> STEVEN
>
>

For the meantime I just want to select text from a menu.

weather is: Fine/cloudy/overcast/raining/storm

Later I would want to compute an answer.



STEVEN
"David McRitchie" <dmcritchie@msn.com> wrote in message
news:O8mwhc9iFHA.3540@TK2MSFTNGP14.phx.gbl...
> Hi Steven,
> And what would you want to do. Make an entry, call a macro.
>
> Take a look at validation where you can get a list of valid entries.
> http://www.contextures.com/tiptech.html
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
news:dbh0af$p7p$1@lust.ihug.co.nz...
> > I want to place a button in or near a cell which allows the selection
from a
> > menu of text items or computed answers. Must be simple but don't know
where
> > to start looking.
> > Can someone help me out on this please?
> >
> > STEVEN
> >
> >
>
>

Hi Steven,
Can't tell from your reply if you found what you wanted or not, so more
specifically to your reply. your list would be in a named range i.e. weather



basic validation with a list of up to 8 choices

Excel -- Data Validation
http://www.contextures.com/xlDataVal01.html

more complicated

Excel -- Data Validation -- Combo box using Named Ranges
http://www.contextures.com/xlDataVal11.html

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steven Young" <syoung@stevenyoung.co.nz> wrote in message news:dblerl$ofs$1@lust.ihug.co.nz...
> For the meantime I just want to select text from a menu.
>
> weather is: Fine/cloudy/overcast/raining/storm
>
> Later I would want to compute an answer.
>
>
>
> STEVEN
> "David McRitchie" <dmcritchie@msn.com> wrote in message
> news:O8mwhc9iFHA.3540@TK2MSFTNGP14.phx.gbl...
> > Hi Steven,
> > And what would you want to do. Make an entry, call a macro.
> >
> > Take a look at validation where you can get a list of valid entries.
> > http://www.contextures.com/tiptech.html
> >
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
> news:dbh0af$p7p$1@lust.ihug.co.nz...
> > > I want to place a button in or near a cell which allows the selection
> from a
> > > menu of text items or computed answers. Must be simple but don't know
> where
> > > to start looking.
> > > Can someone help me out on this please?
> > >
> > > STEVEN
> > >
> > >
> >
> >
>
>

Thank you for your perseverance!

No, I still can't do what I want.

I just want to:

Put a button on a cell
When I click the button there should be a list.
I select the item on that list.
That item could either be text I can't be bothered repeating, or
it points to a look-up table to put a value in another cell or
it points to another cell with a computed value


STEVEN



"David McRitchie" <dmcritchie@msn.com> wrote in message
news:%233%23voUTjFHA.2772@TK2MSFTNGP12.phx.gbl...
> Hi Steven,
> Can't tell from your reply if you found what you wanted or not, so more
> specifically to your reply. your list would be in a named range i.e.
weather
>
>
>
> basic validation with a list of up to 8 choices
>
> Excel -- Data Validation
> http://www.contextures.com/xlDataVal01.html
>
> more complicated
>
> Excel -- Data Validation -- Combo box using Named Ranges
> http://www.contextures.com/xlDataVal11.html
>
> --
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
news:dblerl$ofs$1@lust.ihug.co.nz...
> > For the meantime I just want to select text from a menu.
> >
> > weather is: Fine/cloudy/overcast/raining/storm
> >
> > Later I would want to compute an answer.
> >
> >
> >
> > STEVEN
> > "David McRitchie" <dmcritchie@msn.com> wrote in message
> > news:O8mwhc9iFHA.3540@TK2MSFTNGP14.phx.gbl...
> > > Hi Steven,
> > > And what would you want to do. Make an entry, call a macro.
> > >
> > > Take a look at validation where you can get a list of valid entries.
> > > http://www.contextures.com/tiptech.html
> > >
> > > ---
> > > HTH,
> > > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > >
> > > "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
> > news:dbh0af$p7p$1@lust.ihug.co.nz...
> > > > I want to place a button in or near a cell which allows the
selection
> > from a
> > > > menu of text items or computed answers. Must be simple but don't
know
> > where
> > > > to start looking.
> > > > Can someone help me out on this please?
> > > >
> > > > STEVEN
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Try that data|Validation that David McRitchie suggested.

It sure sounds like it'll do what you want.

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Steven Young wrote:
>
> Thank you for your perseverance!
>
> No, I still can't do what I want.
>
> I just want to:
>
> Put a button on a cell
> When I click the button there should be a list.
> I select the item on that list.
> That item could either be text I can't be bothered repeating, or
> it points to a look-up table to put a value in another cell or
> it points to another cell with a computed value
>
> STEVEN
>
> "David McRitchie" <dmcritchie@msn.com> wrote in message
> news:%233%23voUTjFHA.2772@TK2MSFTNGP12.phx.gbl...
> > Hi Steven,
> > Can't tell from your reply if you found what you wanted or not, so more
> > specifically to your reply. your list would be in a named range i.e.
> weather
> >
> >
> >
> > basic validation with a list of up to 8 choices
> >
> > Excel -- Data Validation
> > http://www.contextures.com/xlDataVal01.html
> >
> > more complicated
> >
> > Excel -- Data Validation -- Combo box using Named Ranges
> > http://www.contextures.com/xlDataVal11.html
> >
> > --
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
> news:dblerl$ofs$1@lust.ihug.co.nz...
> > > For the meantime I just want to select text from a menu.
> > >
> > > weather is: Fine/cloudy/overcast/raining/storm
> > >
> > > Later I would want to compute an answer.
> > >
> > >
> > >
> > > STEVEN
> > > "David McRitchie" <dmcritchie@msn.com> wrote in message
> > > news:O8mwhc9iFHA.3540@TK2MSFTNGP14.phx.gbl...
> > > > Hi Steven,
> > > > And what would you want to do. Make an entry, call a macro.
> > > >
> > > > Take a look at validation where you can get a list of valid entries.
> > > > http://www.contextures.com/tiptech.html
> > > >
> > > > ---
> > > > HTH,
> > > > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > > > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > > > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > > >
> > > > "Steven Young" <syoung@stevenyoung.co.nz> wrote in message
> > > news:dbh0af$p7p$1@lust.ihug.co.nz...
> > > > > I want to place a button in or near a cell which allows the
> selection
> > > from a
> > > > > menu of text items or computed answers. Must be simple but don't
> know
> > > where
> > > > > to start looking.
> > > > > Can someone help me out on this please?
> > > > >
> > > > > STEVEN
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >

--

Dave Peterson