Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list formula | Excel Worksheet Functions | |||
Formula and Drop Down List | Excel Discussion (Misc queries) | |||
adding a formula to items in a drop down list | Excel Discussion (Misc queries) | |||
formula drop down list | New Users to Excel | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |