ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using a combo or list box to select a statement (https://www.excelbanter.com/excel-programming/372871-using-combo-list-box-select-statement.html)

Jurrasicway

Using a combo or list box to select a statement
 
Hi,

I want to use a combo or list box to select a statement from a list of
statements in a selected cell.
What is the best way to do this? Can it be done by using a look up statement
or will I have to use a combo or list box?

Graeme.

Bob Phillips

Using a combo or list box to select a statement
 
Sounds like data validation,

See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jurrasicway" wrote in message
...
Hi,

I want to use a combo or list box to select a statement from a list of
statements in a selected cell.
What is the best way to do this? Can it be done by using a look up

statement
or will I have to use a combo or list box?

Graeme.





All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com