Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Return strings multiple times on clicked cell 1

Status
Not open for further replies.

HU42315

Technical User
Feb 16, 2011
1
US
This macro in excel has user click on a question, sends them to the answer, then when they click on "Return to List of Questions" it places "Reviewed" string next to the question they reviewed. I want this to repeat this process for the rest of the questions in each row, but can get it to work only for the first question. Attaching file with code so far.
 

Hi,
Code:
Public lLastRow As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Cells(Target.Row, "B").Value > 0 Then
        lLastRow = Target.Row
    Else
        Cells(lLastRow, "A").Value = "Reviewed"
    End If
End Sub

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top