Visual Basic for Applications

by Wikibooks contributors

Read here Read at Wikibooks

A book Wikibooks counts as complete, from its open-content textbook collection.

Description from Wikibooks.

Publisher
Wikibooks contributors
Licence
CC BY-SA 4.0, as Wikibooks states it
Who can read
Teens profiles and older, judged from its title and subjects

Contents

  1. Visual Basic for Applications
  2. printable version
  3. Character 1D Arrays
  4. Array Data To Immediate Window
  5. Array Data To WorkSheet (1D or 2D)
  6. Array Output Transfers
  7. Charts from Arrays
  8. Character Frequency Charts in Excel
  9. Clipboard VBA
  10. Simple Vigenere Cipher in VBA
  11. Error Handling
  12. File and Folder Dialogs
  13. Recursive File Listing of Folders
  14. File and Folder Utilities
  15. Font Utilities
  16. The Elusive Hiding Button
  17. String Hashing in VBA
  18. File Hashing in VBA
  19. Folder Hashing in VBA
  20. Running the FCIV Utility from VBA
  21. Use Log Files from VBA
  22. Message Boxes
  23. Input Boxes
  24. Problems Chosing Position for Randomize()
  25. A PRNG for VBA
  26. A Pseudo Random Character Table
  27. Listing Prime Numbers
  28. Big Number Arithmetic with Strings
  29. Excel Sheet True Used Range
  30. Bubble Sort 1D Arrays
  31. Bubble Sort 2D Arrays on One Key
  32. Bubble Sort 2D Arrays on Multiple Keys
  33. Variable Beep from VBA
  34. Play a WAV File from VBA
  35. Make a WAV File from a VBA String
  36. Read Aloud Strings and Text
  37. Get Array Data Stats
  38. Discrete Data Bin Stats
  39. The Knuth String Shuffle
  40. Compare Shuffle Methods for Bias
  41. Backup Text Boxes on Close
  42. Block Illegal Characters
  43. Validate with the Like Operator
  44. Delays Past Midnight
  45. Time Lapsed Between Dates
  46. Date-Time String Formats
  47. Avoiding Change Event Recursion
  48. CommandButton Toggle
  49. Styling User Forms
  50. Check if a Workbook has VBA code
  51. Get the VBA Project Code String
  52. Automatically Indent and Format VBA Code
  53. VBA Code to List Redundant Variables
  54. Viterbi Simulator (CLOSENESS)
  55. Viterbi Simulator (HAMMING DISTANCE)
  56. Generate Random Dictionary Words
  57. Transfer Data to the Worksheet
  58. Worksheet Common Utilities
  59. VBA Code to Read ASCII Log Data from LAS File