Drop List + Formula
Excel 2007
I am looking for help on the following; If cell F26 = 0, then cell F25 should show 15% If cell F26 = anything other than 0, I want to be able to select a percentage amount from a drop down list. |
Drop List + Formula
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$F$26" Then Exit Sub If Target = 0 Then Target.Offset(-1) = 0.05 Else Target.Offset(-1).Validation _ .Add Type:=xlValidateList, _ Formula1:=".10%,.20%,.30%,.45%" Target.Offset(-1).Select End If End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Canon" wrote in message ... Excel 2007 I am looking for help on the following; If cell F26 = 0, then cell F25 should show 15% If cell F26 = anything other than 0, I want to be able to select a percentage amount from a drop down list. |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com