Ping IP Address with VBA code and return results in Excel

by

You don’t need code for this. Turn all the cells red, then add conditional formatting to make it green when you want.

Home > Conditional Formatting > New Rule > Use a formula…

=C2="Connected"

and format to green. If you want to do it in code, you can add some lines in your For Each loop

If Result = "Connected" Then
    Cell.Offset(0,1).Font.Color = vbGreen
Else
    Cell.Offset(0,1).Font.Color = vbRed
End If

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. Test or check if sheet exists
  4. Copy from one workbook and paste into another
  5. How to copy Outlook mail message into excel using VBA or Macros
  6. For Loop not fully cycling in excel VBA [duplicate]
  7. Unique Random Numbers using VBA
  8. Populate unique values into a VBA array from Excel
  9. Excel VBA App stops spontaneously with message “Code execution has been halted”
  10. How to remove all non alphanumeric characters from a string except period and space in excel?
  11. Closing Excel Application using VBA
  12. How to clear memory to prevent “out of memory error” in excel vba?
  13. Assign on-click VBA function to a dynamically created button on Excel Userform
  14. What are the benefits of setting objects to “Nothing”
  15. Using a wildcard to open an excel workbook
  16. How can I kill task manager processes through VBA code?
  17. VBA: Usage of parentheses for a method
  18. Fully reference a worksheet by codename
  19. OnTime for less than 1 second without becoming Unresponsive
  20. Get Unicode characters with charcode values greater hex `FFFF`
  21. How do I click a link on a web page using Excel VBA?
  22. ‘1004’: “The sort reference is not valid.”
  23. Select entire column in table using Excel VBA
  24. Create hyperlink to another sheet
  25. Reducing WithEvent declarations and subs with VBA and ActiveX
  26. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  27. Function Overloading and UDF in Excel VBA
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment