• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

POP Message

@bobby23

New Member
HI, How to create a pop up message if the Required cell to fill in is not filled? or not enter the data?

not all cell only selected. example: only fill Cell b2, b4, b7, b10 like that.
 
Hi, a VBA demonstration as a beginner starter :​
Code:
Sub Demo1()
         Dim Rg As Range, S$
    For Each Rg In [B2,B4,B7,B10]
        If IsEmpty(Rg) Then S = S & IIf(S > "", ", ", "") & Rg.Address(False, False)
    Next
        If S > "" Then MsgBox "You must fill " & S, 48, "Control"
End Sub
Do you like it ? So thanks to click on bottom right Like !
 
Hi how to create Pop Up message in this selected cells contains more than 60 selected cells.
A101,A103,A105,A107,A109,A111,A13,A115,A117,A119,A121,A124,A126,A128,A30,A132,A134,A136,A138,A140,A142,A144,A146,A148,A150,A152,A154,A156,A213,A215,A217,A224,A226,A228,A230,A232,A234,A236,A238,A240,A242,A249,A251,A253,A255,A257,A259,A261,A269,A271,A273,A275,A277,A279,A281,A288,A290,A292,A299,A301,A303.
please help
 
Back
Top