Reason for adding the line Range("R19").ClearComments:I am not sure what the point is about the code lines that you have added like
Range("R19").Select
Range("R19").ClearComments
???
Actually, I've added a line in the Macro which add a comment box in the Cell R19 automatically, after Selecting "Single-Parent Family" in the cell RJ. So, it needs to be cleared on changing selection.
Reason for adding the line Range("R19").Select
I want that when a value is selected in the cell J19, the cursor automatically moves to the cell R19 to get the attention of the user, so that the user can easily enter the remarks, or take a look, at least. (Sorry That I was forget to mention it in my previous reply)
Here is the added code...
Code:ElseIf RngTgt.Value = "Single-Parent Family" Then Let Application.EnableEvents = False Let Range("R19").Value = "(Select Reason for Single-Parent)" Let Application.EnableEvents = True Let Range("R19").Font.Color = 10855845 Let RngTgt.Font.Color = 6751362 With Range("R19").Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="Expired {One is No More},Divorced {Separated Legally},Break-Up {Attachment Hampered},Abandonment {Fully Separated},Enter Reason Manually" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "Error!" .InputMessage = "" .ErrorMessage = "To enter the reason manually, please select the option 'Enter Reason Manually'" .ShowInput = True .ShowError = True End With Range("R19").Select Range("R19").AddComment Range("R19").Comment.Visible = False Range("R19").Comment.Text Text:="Reason for Single-Parent"




Reply With Quote
Bookmarks