Files at www.zorvek.com

– Selva V Pasupathy, HSBC Global Resourcing, Hyderabad1

Some very good Excel VBA Example files from http://www.zorvek.com. I learned few more tricks and tips here, and hope this helps someone somewhere to learn something.

  1. http://www.zorvek.com/downloads/2005_HMC_Data_SourceEmail.xls
  2. http://www.zorvek.com/downloads/Auto-Adjust-Rows.xls
  3. http://www.zorvek.com/downloads/Change-External-Links-V3.xls
  4. http://www.zorvek.com/downloads/Copy of Apps Baseline.xls
  5. http://www.zorvek.com/downloads/Currency_Conversion.xls
  6. http://www.zorvek.com/downloads/Diary.xls
  7. http://www.zorvek.com/downloads/Dummy_Transaction_Data_2.xls
  8. http://www.zorvek.com/downloads/EE_Q_TextBoxes_All_Over.xls
  9. http://www.zorvek.com/downloads/ee-21567843-iterate-file-structure.xls
  10. http://www.zorvek.com/downloads/ee-21580040-progress-bar-in-user-form.xls
  11. http://www.zorvek.com/downloads/ee-21589098-prompt-a-message.xls
  12. http://www.zorvek.com/downloads/ee-21592877-now-in-protected-field.xls
  13. http://www.zorvek.com/downloads/ee-21612124-select-only-required-value.xls
  14. http://www.zorvek.com/downloads/ee-21634517-change-color-of-cell.xls
  15. http://www.zorvek.com/downloads/ee-21635903-autochange-color-code.xls
  16. http://www.zorvek.com/downloads/ee-21641954-time-calculation.xls
  17. http://www.zorvek.com/downloads/ee-21662320-formula-to-find-mileage.xls
  18. http://www.zorvek.com/downloads/ee-21675916-looking-for-a-way.xls
  19. http://www.zorvek.com/downloads/ee-21680207-vba-data-from-variant.xls
  20. http://www.zorvek.com/downloads/ee-21682541-earlier-solutions-not-working.xls
  21. http://www.zorvek.com/downloads/ee-21687654-changing-advanced-filter.xls
  22. http://www.zorvek.com/downloads/ee-21688255-adding-a-loop.xls
  23. http://www.zorvek.com/downloads/ee-21691314-grading.xls
  24. http://www.zorvek.com/downloads/ee-21692379-grading-continued.xls
  25. http://www.zorvek.com/downloads/ee-21697601-graphing.xls
  26. http://www.zorvek.com/downloads/ee-21707557-importing-addresses-to-excel.xls
  27. http://www.zorvek.com/downloads/ee-21714170-codename-excel-2003.xls
  28. http://www.zorvek.com/downloads/ee-21736452-have-a-basic-sales-register.xls
  29. http://www.zorvek.com/downloads/ee-21754257-creating-dropdowns.xls
  30. http://www.zorvek.com/downloads/ee-21755075-line-of-credit-template.xls
  31. http://www.zorvek.com/downloads/ee-21836816-VLOOKUP-Example.xls
  32. http://www.zorvek.com/downloads/ee-21838481-sumproduct-question.xls
  33. http://www.zorvek.com/downloads/ee-21847277-graphic-in-a-userform-V2.xls
  34. http://www.zorvek.com/downloads/ee-21865675-coding-a-sort-in-vba.xls
  35. http://www.zorvek.com/downloads/ee-21871766-sumproduct-and-wildcards.xls
  36. http://www.zorvek.com/downloads/ee-21874023-find-all-of-the-same.xls
  37. http://www.zorvek.com/downloads/ee-21942813-how-to-sort-by-formula-values.xls
  38. http://www.zorvek.com/downloads/ee-21952814-formula-needed.xls
  39. http://www.zorvek.com/downloads/ee-21960639-help-with-formula.xls
  40. http://www.zorvek.com/downloads/ee-21983720.xls
  41. http://www.zorvek.com/downloads/ee-21983783.xls
  42. http://www.zorvek.com/downloads/ee-21995783-code-write-up.xls
  43. http://www.zorvek.com/downloads/ee-22014718-how-to-add-data.xls
  44. http://www.zorvek.com/downloads/ee-22016531-formatting-issue.xls
  45. http://www.zorvek.com/downloads/ee-22019603-pop-up-picture.xls
  46. http://www.zorvek.com/downloads/ee-22022532-split-name-field.xls
  47. http://www.zorvek.com/downloads/ee-22032698-using-excel-vb.xls
  48. http://www.zorvek.com/downloads/ee-22038078-sort-data-without-changing-format.xls
  49. http://www.zorvek.com/downloads/ee-22040257-bonus.xls
  50. http://www.zorvek.com/downloads/ee-22040765-how-to-highlight.xls
  51. http://www.zorvek.com/downloads/ee-22040964-need-to-get-a-sum.xls
  52. http://www.zorvek.com/downloads/ee-22041488-looking-for-the-right-formula.xls
  53. http://www.zorvek.com/downloads/ee-22046074-excel-chart-x-axis.xls
  54. http://www.zorvek.com/downloads/ee-22048807-auto-filter.xls
  55. http://www.zorvek.com/downloads/ee-22052833-how-to-randomize-a-row-of-data.xls
  56. http://www.zorvek.com/downloads/ee-22054708-defined-names.xls
  57. http://www.zorvek.com/downloads/ee-22056742-i-want-to-create-a-drop-down.xls
  58. http://www.zorvek.com/downloads/ee-22056768-expand-list.xls
  59. http://www.zorvek.com/downloads/ee-22060409-code-to-run-autofilter.xls
  60. http://www.zorvek.com/downloads/ee-22060409-code-to-run-autofilter-2.xls
  61. http://www.zorvek.com/downloads/ee-22064886-user-defined-function.xls
  62. http://www.zorvek.com/downloads/ee-22065022-combine-if-else.xls
  63. http://www.zorvek.com/downloads/ee-22065762-formula-formatting-question.xls
  64. http://www.zorvek.com/downloads/ee-22101181-advanced-filtering-in-excel.xls
  65. http://www.zorvek.com/downloads/ee-22102019-hyperlinks-in-a-download.xls
  66. http://www.zorvek.com/downloads/ee-22103781-problems-with-combobox.xls
  67. http://www.zorvek.com/downloads/ee-22104413-the-matching-game.xls
  68. http://www.zorvek.com/downloads/ee-22110965-chart-help-urgent.xls
  69. http://www.zorvek.com/downloads/ee-22112680-rank-data.xls
  70. http://www.zorvek.com/downloads/ee-22115059-how-to-make-cell-value-blink.xls
  71. http://www.zorvek.com/downloads/ee-22119713-excel-text-color.xls
  72. http://www.zorvek.com/downloads/ee-22128065-automatically-run-macro.xls
  73. http://www.zorvek.com/downloads/ee-22135373-password-test.xls
  74. http://www.zorvek.com/downloads/ee-22138225-vba-control-box.xls
  75. http://www.zorvek.com/downloads/ee-22141573-inserting-blank-rows.xls
  76. http://www.zorvek.com/downloads/ee-22148770-get-2-column-index-cards.xls
  77. http://www.zorvek.com/downloads/ee-22494446-optionbuttons-combination.xls
  78. http://www.zorvek.com/downloads/ee-22517578-testexample.xls
  79. http://www.zorvek.com/downloads/ee-22534714-excel-max-and-min-function.xls
  80. http://www.zorvek.com/downloads/ee-22689895-excel-guru-required.xls
  81. http://www.zorvek.com/downloads/ee-22697495-randbetween.xls
  82. http://www.zorvek.com/downloads/ee-22730906-add-a-second-criteria.xls
  83. http://www.zorvek.com/downloads/ee-22739416-if-statement-with-percentages.xls
  84. http://www.zorvek.com/downloads/ee-22854628-count-blank-cells.xls
  85. http://www.zorvek.com/downloads/ee-22971857-1.xls
  86. http://www.zorvek.com/downloads/ee-23094960-1.xls
  87. http://www.zorvek.com/downloads/ExcelTest4_11_06.xls
  88. http://www.zorvek.com/downloads/expression.xls
  89. http://www.zorvek.com/downloads/Find-Text-in-Workbooks.xls
  90. http://www.zorvek.com/downloads/Folder-File-List.xls
  91. http://www.zorvek.com/downloads/Football-Pool.xls
  92. http://www.zorvek.com/downloads/Hover-Example.xls
  93. http://www.zorvek.com/downloads/IMB2BPMO1.xls
  94. http://www.zorvek.com/downloads/Lock.xls
  95. http://www.zorvek.com/downloads/Log-Analysis-Reports-1.06.xls
  96. http://www.zorvek.com/downloads/Pantone_Color_Mix_Calculator.xls
  97. http://www.zorvek.com/downloads/Personal_Day_Manager.xls
  98. http://www.zorvek.com/downloads/Process_Files.xls
  99. http://www.zorvek.com/downloads/progress-bar-example.xls
  100. http://www.zorvek.com/downloads/Quit-Test.xls
  101. http://www.zorvek.com/downloads/Set-File-Dates.xls
  102. http://www.zorvek.com/downloads/Sort-and-Filter-Example.xls
  103. http://www.zorvek.com/downloads/SubMaterial_Simple.xls
  104. http://www.zorvek.com/downloads/SubMaterial_Simple_V2.xls
  105. http://www.zorvek.com/downloads/SubMaterial_Test.xls
  106. http://www.zorvek.com/downloads/Survey-Completion-Log.xls
  107. http://www.zorvek.com/downloads/Survey-Completion-Log-V2.xls
  108. http://www.zorvek.com/downloads/Userform_trials-v2.xls

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: