Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List function? LiveUser Excel Worksheet Functions 0 February 28th 08 09:12 PM
Which function wd I use to set up a ref to a list of possible name Twishlist Excel Worksheet Functions 4 April 18th 07 07:14 AM
want to use list, while using if function? rvs Excel Worksheet Functions 1 August 30th 06 01:27 PM
List Function Andrew Excel Worksheet Functions 1 April 8th 05 07:07 AM
Can I use a List in a IF Function? Matt Excel Worksheet Functions 6 November 24th 04 09:39 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"