Adding validation list based on a selection by macro?

NoSparks · #2 11-27-2021, 08:55 AM

Quote:

For example, if I selected A101:A103, This macro would add a validation list in A100, including values of A101:A103.

Code:

Sub testing()
 
With Selection.Cells(1).Offset(-1).Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
    xlBetween, Formula1:="=" & Selection.Address
    .IgnoreBlank = True
    .InCellDropdown = True
    .InputTitle = ""
    .ErrorTitle = ""
    .InputMessage = ""
    .ErrorMessage = ""
    .ShowInput = True
    .ShowError = True
End With
    
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text based on selection of dropdown list	cloud67	Word VBA	2	08-09-2019 06:46 AM
Autofill a field based on drop down list selection	lascough20	Word	2	09-21-2018 02:24 AM
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list	Irimi-Ai	Word	5	04-25-2017 09:31 AM
Data Validation List based on Two Named Ranges	Rich18144	Excel	4	01-14-2016 04:37 AM
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM