Macros based on Data Validation !!

[mohan_2mm]

Hi,

Is it possible to run macro on basis of Data validation?

Regards,
M

 

[Andrew Poulsom]

The Worksheet_Change event procedure will fire if the user changes a cell that contains Data Validation, if that's what you mean.

 

[Ruddles]

Even if the cell in question doesn't actually change. Grr!

 

[mohan_2mm]

Thank you. yes I was looking for Worksheet_SelectionChange but can i get code to simple macro to run on basis of Data Validation.

I have a data validation in Cell C4 When user changes it a macro should fire.

Thank you so much.

 

[Andrew Poulsom]

Yes, you need the Worksheet_Change event procedure. Example:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$C$4" Then Exit Sub
'   Replace next line with your code
    MsgBox "You changed " & Target.Address(False, False)
End Sub

 

[mohan_2mm]

Thats great. It really served the purpose what i was looking.

Thank you so much.

 

[kissu]

Hi

I need to have the excel cell (say A2) accept only one value,say "ABC".The cell should not accept any other value except "ABC".Could someone help me with the code?

Many thanks!!
kissu

 

[Andrew Poulsom]

Welcome to MrExcel.

You can use Data Validation with Allow Custom and the Formula:

=EXACT(A2,"ABC")

 

[kissu]

Thank you very much, but i want to use VB code to do this.
I need to do validate 20 cells with different criteria.

For eg.,I need one cell to accept any of the two values,say "ABC" or "DEF"
i.e.,the particular cell should accept any of those two values only and if any thing is typed other than these two strings then it should n't allow the person to enter the value....


It may seem very basic but I an amateur and keen to learn macros.
Please help me here..

many thanks once again for your response!!

 

[number kruncher]

If the Data Validation, List option was chosen, then the user would be prompted with the required result(s).