Buttons

[Steven Young]

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

 

[David McRitchie]

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

 

[Steven Young]

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

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

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

 

[David McRitchie]

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

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

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

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

 

[Steven Young]

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

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

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

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

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]

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

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

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

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

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