Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Spreadsheet VBA validation in Cell
Name:
Robert
Email (spam proof):
Email the originator of this post
Date:
Friday, August 06, 2004
Hits:
63
Discussion (Terms and Conditions):
Hello there, I am setting up a spreadsheet for levels but I am having troubles with some VBA code behind the spreadsheet. I have attached the spreadsheet. Here is the code I have so far.. What I am trying to do is filter the user selection so that the list is only generated if the user selects column 1(A) Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Cells.Column = 2 Then With ActiveCell(A1) .Validation.Delete .Validation.Add xlValidateList, , , "=ListRange" End With End If End Sub

Sponsored by the best FTP application on the internet: