View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default 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?