Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown in cell base on a selection of a different drop down
Hi all, I'm wondering if someone can help me out here. I'm trying to automate
an excel sheet whereby a selection of a value form a drop down list will present a differnt dropdown in adifferent cell. However my code is throwing Run-time error 1004. Below is the code and the debug point to .Ignoreblank = true Dim CommentRed As String Dim CommentAmber As String Dim CommentGreen As String CommentRed = "OTC, WIP in course, Credit in course, Credit Submitted" CommentAmber = "Credit Approved, Awaiting Confirmation, In documentation" CommentGreen = "In documentation, Deal Completed" If Target.Column = 4 Then ThisRow = Target.Row With Range("E" & ThisRow).Validation .Delete Select Case Range("M" & ThisRow).Value Case "WIP Red" .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlEqual, Formula1:=CommentRed Case "WIP Amber" .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlEqual, Formula1:=CommentAmber Case "WIP Green" .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlEqual, Formula1:=CommentGreen End Select .IgnoreBlank = True .InCellDropdown = True End With End If Can some one please help me out. I'm behind deadline |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dropdown list based on selection from a differernt drop | Excel Discussion (Misc queries) | |||
Can a Dropdown list change neighoring cells base of what is select | Excel Discussion (Misc queries) | |||
How do you lock a cell after making a selection from a dropdown b | Excel Worksheet Functions | |||
VLOOKUP or dropdown in the cell depending on selection in another | Excel Discussion (Misc queries) | |||
DropDownBoxes Which update base on other dropdown values | Excel Programming |