Need vba code

[udhaytirupur]

Hi frnds .,

i need vba code to find text "pass" in any of cell range in "c3:c16" and give pop up message by mentioning student name which is next cell of displaying text cell ...



For example : If in " c10 " if text displayed as "pass" then pop up message should come name of student in "d10" cell ...

And if one or more text displayed as " pass " in given cell range then one by one alert pop up msg should come ....


Thanks in advance ....

[NickyC]

try this

Please Login or Register  to view this content.

[Marc L]

A VBA demonstration as a beginner starter :

Sub Demo1() 
    V = Filter([TRANSPOSE(IF(C3:C16="pass",D3:D16))], False, False) 
    If UBound(V) > -1 Then MsgBox Join(V, ", ") 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[udhaytirupur]

a vba demonstration as a beginner starter :

sub demo1() 
    v = filter([transpose(if(c3:c16="pass",d3:d16))], false, false) 
    if ubound(v) > -1 then msgbox join(v, ", ") 
end sub  

► do you like it ? ► ► so thanks to click on bottom left star icon « ★ add reputation » ! ◄ ◄

thnx man ... Thanks for ur help ..... Its working ....... ,
while running the code it shows msg box for condition .... But if the data changes in dynamic in live if newly text "pass" appears msg box not showing ....

[udhaytirupur]

try this

Please Login or Register  to view this content.

thanks for considering & ur help ...
But code doesnt work for me ..... No error in code but msg box not showing ....

[Marc L]

As both codes well work …

But if the data changes in dynamic in live if newly text "pass" appears msg box not showing ....

But that was not explained in the initial post ! So include the code in the 'Worksheet_Change' event in the worksheet module …