Thanks so much zepphead80, you were so helpfull. its working now. I learned alot from it and it refreshed my knowledge also.
thanks again
suraj269
Last Activity: Sep 28 '10, 08:08 PM
Joined: Jun 21 '10
Location:
-
i created Module 1 and wrote the following (and compiled)
Public Function GetMessage(strR ange) As String
Select Case Range(strRange)
Case "NO", "N/A"
GetMessage = "Details Required"
Case "YES"
GetMessage = ""
End Select
End Function
Private Sub Worksheet_Chang e(ByVal...Leave a comment:
-
i am writing
=GetMessage(B12 ) and then i have tried =GetMessage("B1 2")
both gives me #Name error.
I have added necessary Add-Ins but still getting same error...Leave a comment:
-
i am calling the funtion but getting #name error...Leave a comment:
-
i dont understand what do you mean by Application.cal culate.....Leave a comment:
-
Range...Excel how to replicate same code
this code works very well for the one cell B12, where selection made reflects message change in C12.
i want to do it for series of rows.
Like B13, C13 and then B14, C14 , .....and so on.
can someone please help
If Range("B12") = "N/A" Then ' Drop down value selection
Range("C12") = "Details required"
ElseIf Range("B12")...
No activity results to display
Leave a comment: