I wrote some code to change the source of the drop down list. When a user selects a value from a list in AG3 then the source of AG4 is changed. It works in Excel 64 but I get an error stating the procedure is too large when someone tries to run it in Excel 32.
I've tried to find out how to put all the values and source ranges in an Array but I wasn't able to figure it out.
If Not Intersect(Target, Range("AG3")) Is Nothing And InStr(1, Range("AG3"), "5.75") > 0 Then With Range("AG4").Validation .Delete .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="='DropdownLists'!P2:P6" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With End If
I paste about 100 of these just changing the user selection (5.75) and the range of the drop down list in AG4 (P2:P6). If someone can show me how to put these values in an Array I think I can fix it.