Sign in to submit new ideas and vote
Get Started

Form to Modify Existing Row

I would like to request an option for a form to modify an existing row, identification based on a column of the users choice. I can write the script for you. It can't take more than a dozen lines.

e.g

Set Target1 = User_Input 'Project 1

For each cell in Range("Project") 'Column 1

txt = cell.value

If txt Like Target1 Then

Set Target_Range = cell.EntireRow

Exit Sub

End If

Next cell

etc.

1
1 votes

Idea Submitted · Last Updated