|
|
#3
10-20-2013, 06:38 PM
|
|||
|
|||
Hi
Attached the worksheet I am working on basically it is an engineering design problem: 1- In cell AA I have a dropdown list with values going from 10, 20, 30, and up to 100. 2- In cell CE I have a value as long as this value is less than 1 then the design is safe. 3- In cell CF I have a what if formula [=IF(CE10<=1,"Safe","Unsafe")] if the value in cell CE is less than 1 then the design is safe if it is more than 1 than the design is unsafe. What I want the macro to do is go through the values in the dropdown list in AA one by one as long as the formula in CF states it is safe then it is ok, however if it returns with an answer unsafe than that the wrong answer. I want the macro to stop at the last value in the dropdown list that will give the answer safe. For example subjecting a member to a force 50 is safe however if it is subjected to a force 60 it will become unsafe. Basically I want the answer that will give me the max force a member can take before becoming unsafe. Thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA: How to place dropdown list next to text | YigalB | Word VBA | 0 | 08-11-2013 01:48 PM |
| block selection in dropdown list | Intruder | Excel | 2 | 01-10-2013 10:20 AM |
 dropdown list for documents
|
r_p_t_0 | Word | 2 | 12-18-2012 05:55 AM |
|
Can I have a dropdown list to choose from in mail merge?
|
lawlaw | Mail Merge | 3 | 11-29-2012 04:47 PM |
| Dropdown list of email addresses | J Partridge | Outlook | 1 | 01-13-2011 06:37 AM |
Windows 7 64bit 
Office 2007
Threaded Mode