What does the keyword Set actually do in VBA? [duplicate]

by

set is used to assign a reference to an object. The C equivalent would be 

 int i;
int* ref_i;

i = 4; // Assigning a value (in VBA: i = 4)
ref_i = &i; //assigning a reference (in VBA: set ref_i = i)

More Related Contents:

  1. Why Use Integer Instead of Long?
  2. How do I get the old value of a changed cell in Excel VBA?
  3. Force a screen update in Excel VBA
  4. Find all matches in workbook using Excel VBA
  5. Create a new sheet for each unique agent and move all data to each sheet
  6. Set Auto Filtering multiple wildcards
  7. How to make Excel VBA variables available to multiple macros?
  8. VBA collection: list of keys
  9. When one should use Set [e.g for SpecialCells return value]?
  10. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  11. Determining whether an object is a member of a collection in VBA
  12. Excel VBA How to detect if something was pasted in a Worksheet
  13. Getting error Procedure too large in VBA Macros (Excel)
  14. VBA ServerXMLHTTP https request with self signed certificate
  15. How to add data validation to a cell using VBA
  16. Getting AD Details based on username
  17. Environ Function code samples for VBA
  18. What is the best way to access a serial port from VBA?
  19. How to copy a chart from Excel to PowerPoint?
  20. vba paste not working
  21. mac excel vba loop : from list & then export as pdf
  22. How to add an embedded image to an HTML message in Outlook 2010
  23. Speed up multiple replacement
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel VBA: auto click and open file from website
  26. How can I automatically populate the VBA Editor with line numbers?
  27. Calling regasm without administrative rights for COM interop in Excel VBA
  28. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  29. How do I activate a specific workbook and a specific sheet?
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment