• 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.

Click cell on that row column 11 add word

kalua1231

Member
Hello chandoo users and ninjas

I am trying to add a macro on a button

On any clicked cell
Look for that exact row
Column 11
Put in the word (DONE)

Thanks for your help guys.
 

Attachments

  • Click on cell on that row column 11 put in DONE.png
    Click on cell on that row column 11 put in DONE.png
    79 KB · Views: 1
  • Click on cell on that row column 11 put in DONE 2.png
    Click on cell on that row column 11 put in DONE 2.png
    75.7 KB · Views: 1
  • FIXED COMPLETED 9 6.xlsm
    200.9 KB · Views: 1
Copy the code below and place it in the Code Module 1

Then link the Button Done to it

Code:
Sub Done()
  Cells(ActiveCell.Row, 11) = "DONE"
End Sub
 
Back
Top