How do you change the value of a cell in excel by clicking on it using VBA? [closed]

by

This would work:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Value = "In service" Then
        Target = "Out of service"
    ElseIf Target.Value = "Out of service" Then
        Target = "In service"
    End If
End Sub

More Related Contents:

  1. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  2. Excel VBA – How to add dynamic array formula
  3. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  4. Check if the file exists using VBA
  5. How can I create a progress bar in Excel VBA?
  6. Compare double in VBA precision problem
  7. Row count on the Filtered data
  8. Excel VBA Macro: User Defined Type Not Defined
  9. Automate IE via Excel to fill in a dropdown and continue
  10. Run-Time error 1004 Excel 2013
  11. VBA – Write all possible combinations of 4 columns of data [duplicate]
  12. Pasting an Excel range into an email as a picture
  13. Excel VBA to Export Selected Sheets to PDF
  14. Remove duplicates from array using VBA
  15. Controlling Internet Explorer local intranet using Excel VBA
  16. How to automatically insert a blank row after a group of data
  17. Rounding in MS Access
  18. Count unique values in Excel
  19. Get File Path (ends with folder)
  20. Get length of array?
  21. Email a single attachment from folder of files each to a different person
  22. Bad data selection using VBScript , on date field values
  23. Sending object array to variant works before August 2019 Windows update, but fails after update
  24. Find last row in range
  25. Differences between Excel’s Form Controls & ActiveX Controls
  26. Excel VBA User Defined Function that counts cells with conditional formatting
  27. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  28. Access files with long paths (over 260)
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment