Search results

Hi Narayan, I'm so grateful for your last contribution which has set me straight. Your method is much more direct and not prone to the problems I'd unnecessarily caused myself due to my inexperience. I've now restructured my worksheet entirely. I finally discovered that the macro wasn't...

Hi Narayan, Thanks for going to that effort. There are differences and your method definitely works, so I'll consider this further before responding. Regards, Bart

Hi Narayan, If I delete the contents of O2 and leave it blank then I get a message stating "Microsoft Excel cannot calculate a formula" -probably because other cells use the value of O2. However, if I enter the formula in a blank cell such as E50 and change the range to E50 in the drop down...

Hi Narayan, Thank you for your patience. Cell O2 is never empty. When the Workbook is opened the default value there is set by the formula and represents the minimum quantity allowed. {=INDEX(lstMinQty,MATCH(valSize&valDirection&valUps,lstSize&lstDirection&lstUps,0))} Note, I've also got...

Hi Narayan, Thanks for your comments. A selection in a combo box does change the value in one or two of valSize, valDirection, valUps. Initially, the formula in 02 is =INDEX(lstMinQty,MATCH(valSize&valDirection&valUps,lstSize&lstDirection&lstUps,0)) and any selection change in Dropdown1 or...

Thanks Narayan -the only problem now is that the macro doesn't run automatically when a new selection is made in Dropdown 1 or 3. It does if I go to Tools menu >Macro >Macros > Run I've conducted a search to find a solution, but without success. Any ideas?

Dear members, When a user makes a new selection in either Combo box DropDown1 or DropDown3, I want the following formula to be called upon to place a value in cell O2. {=INDEX(lstMinQty,MATCH(valSize&valDirection&valUps,lstSize&lstDirection&lstUps,0))} The resulting value in O2 informs the...

Thank you both Luke and Narayan for your responses. Narayan, your solution is perfect and resolves all three problems -many thanks!

Hello members, Basically, I have a number of Combo box drop down lists set up using 'Format Control' in Excel for Mac 2004. Some of these lists use the index value from a preceding list to determine the items to be shown. That all works fine in that the correct options are always displayed in...