ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   List Box and IF function (https://www.excelbanter.com/excel-worksheet-functions/228545-list-box-if-function.html)

Jenny Beech

List Box and IF function
 
I need to use the results of a list box choice in an IF statement. How can I
do this?

Joerg Mochikun

List Box and IF function
 
1) Set the "Cell Link" for your list box (that's the cell that will receive
the value that the user selects from from list box).
2) Reference that cell in your IF statement

"Jenny Beech" wrote in message
...
I need to use the results of a list box choice in an IF statement. How can
I
do this?





All times are GMT +1. The time now is 12:15 AM.

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