PDA

View Full Version : Excel Programming


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 [36] 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309

  1. Validation Formula
  2. Insert into last row via Message Box
  3. Only Display If
  4. Showing data on one sheet from another
  5. delete or move file using macros
  6. Combobox to select worksheet?
  7. Variable losing Value while going through IsNumeric
  8. VBA reading + comparing values in the cell
  9. Selecting Cells with a Macro
  10. Delete rows with a specific cell value of >9
  11. Ontime macro
  12. calulating hours worked between two dates
  13. Transversing through the col.
  14. Pop Up Keypad
  15. editing non-numeric data so Excel will recognize it as a Date
  16. Same code one works and one does not?
  17. count quantity of each unique value
  18. Function to copy values into new sheet
  19. Function to copy values into new sheet
  20. Merging Vertical fields up if fields to either side are empty
  21. Auto-replace typed contents in a cell with a formula
  22. macro to run database query
  23. Importing External Data
  24. Sort Range of Sheets (Tabs)
  25. Customizing Web Queries
  26. Paste to the next row
  27. Stop Embeded WAV File In Excel
  28. Do While Case is Syntax problem
  29. Saved selection to txt file: formatting issue (excess " " created) How to get rid of?
  30. VLookUp
  31. Copy Cells down the column
  32. Excel 2000 command button in not functioning in 2003
  33. Sorting Data using Macros
  34. Copy data - Pivot Table
  35. Filling unmerged cells
  36. How to calculate day work payment
  37. Change Worksheet_Change sub to an ordinary sub
  38. Extracting multiple charts
  39. Hide Chart Series using Checkbox
  40. Prevent delete on drop down menu
  41. Help with First bit of VBA please
  42. Capital Letters
  43. excel to a shared outlook appointment
  44. Multi-colour conditional format problem
  45. Run-time error 1004, application-defined or object-defined error
  46. Protect Sheet Window
  47. How to check if Excel is Dirty on changing Cell Value
  48. Date or Cancel
  49. Checking To See If File Is Already Open
  50. Question regarding clear contents function
  51. deleting worksheet
  52. VBA Sort by Closest to TODAY
  53. Activesheet!
  54. hiding sheets in workbook
  55. Insert 4 rows for each weekday
  56. Pivotfields & Pivotitems VBA
  57. Not generating/displaying empty cells in a pivot table
  58. Webcam embed
  59. build a macro that saves & names a file with the current day's date
  60. Different colour of font for various items in ListBox!
  61. How to solve to maximize a value using weighting values
  62. Excel 2007 to Powerpoint 2007: Remains in memory
  63. Conditional Formating
  64. Adding comments to cells
  65. Isolating formulas to work only on native worksheet
  66. Auto Color Sheet tabs with Button
  67. Data separation to new worksheet
  68. Check to see if myRange is blank
  69. Print Formula
  70. App to open user's email client, attach file
  71. Clear worksheet from arrows
  72. create a new sheet macro
  73. A quick method to undo a simple cut & paste macro
  74. Conditional Formatting for a Formula??
  75. Shrinking workbook size
  76. Data Seperation
  77. Searching And Printing From Multiple Workbooks
  78. Inserting whether a worksheet is protected
  79. ListBox Error
  80. Identifying Duplicates then deleting them and cells either side
  81. Drop down list Vaildation using VB programming
  82. Autopopulate text to 2 worksheets with different formats
  83. Gathering Information from Radial Buttons
  84. Zip excel sheets and send by email
  85. IfError
  86. Open Search Companion with VBA
  87. Click on a Cell and Run Macro
  88. macro for summation by month
  89. Autofilter Deletes Not Just Segmented Data
  90. Run a Macro by Click on Cell
  91. Hyperlink
  92. Faulty Code
  93. vba calculator question
  94. VBA problem with form going from 2003 to 2007
  95. ranking second number between two words
  96. activate pop up from formula
  97. Option button caption
  98. Help with External Web Query VBA code
  99. Date/Time Comparison
  100. Change Cell Value
  101. Hide picture by default, display if macros enabled
  102. Trying to call access functions in excel
  103. Copying a macro
  104. How to disable a question?
  105. Clear an array to be completely Blank
  106. Simple copy paste problem
  107. Checkbox or listbox?
  108. Excel Add-Ins to log from OPC Server
  109. Big Sheet In - Small Sheet Out, need program?
  110. Selection.AutoFill error
  111. I mixed , help me in VLOOKUP()
  112. in VBA read values in [] and colour the cell
  113. Need to Overlook part of a file name in a macro
  114. im new to this forum & want learn excel vba
  115. Dialog/Tick box allowing multiple choices
  116. pivot table macro looking at same sheet
  117. How to move cells to another column based on a certain value
  118. to Extract tracked changes and Comments from MS Word 2003 Document
  119. Copy Table from Excel to Word thru VBA
  120. Content/value from shape (dropdown)
  121. Knowing which button was clicked on UserForm?
  122. Combining 2 Workbook_Open commands
  123. inventory assistance
  124. Web Query
  125. Condensing vlookup and search function
  126. ... how to sort entries in multiple comboboxes, filled by a variant...
  127. converting color value to Hex
  128. Auto Sort
  129. Changing Plot Area color of Chart using VBA
  130. Filtering Data in excel
  131. Input Boxes
  132. Automatically create rows of defined data in a new sheet
  133. how do I protect my vba programming from being seen
  134. Add-ins, uitilities in Excel
  135. Open new excel instance - bug
  136. Copying an image into the clipboard
  137. User Input Box - "Yes" and "No"
  138. charting data
  139. outputting data
  140. Combine multiple macros to be as one?
  141. Inputting items into a Combo Box
  142. Select Case Statements
  143. Add three ranges
  144. Importing data into excel
  145. Increment Until value is reached
  146. Userform textbox link issue
  147. Stop Users Seeing Your Excel Formula
  148. Automated Import of .csv File into Excel Using Variable as Connection Path?
  149. zero in the mail
  150. How to disable Outlook Message while Mailing in a macro?
  151. Entering in data in specific cells using range protect or locking the cells
  152. VBA Sub Procedures
  153. Transferring List box contents to another list box on another form
  154. tough question for the best of the best
  155. do I need digital signature
  156. how do I validate sheet names?
  157. Problem with Formula
  158. macro to convert those filepaths into a ready-to-click hyperlink
  159. Invalid, Unqualified Referance error
  160. Using SaveAs & changing the path a file is saved at
  161. Can I use a Loop in this case?
  162. Setting Named Range A = Named Range B
  163. Macro - Series of formulas in a loop to build tables
  164. Copy Data to New Workbook based on Criteria
  165. Merging multiple excel documents into one.
  166. change the tab movement
  167. Macro Button To open PDF File
  168. excel macro
  169. Shortening Massive TextBox Macro
  170. Message Box autoclose
  171. Programming An Option Button
  172. create individual worksheep for each record
  173. How to open a workbook with partial Name?
  174. help with debugging
  175. Do until loop based on date calculation
  176. VBA - how to install
  177. Removing an Item from a List
  178. Copying Unique Records to a New Sheet
  179. Macro Buttons
  180. Listing files contained in a folder
  181. how do I protect my macro from being seen
  182. Macro to Find 1st Blank cell
  183. Need help with excel code...
  184. skip the read only prompt when I open a file
  185. comparing range
  186. Using function .find with Dates (from a Form)
  187. How to call a subroutine in another workbook
  188. PDF Converter To Excel
  189. Writing code to another file
  190. macro to blank combo box selection
  191. Timestamp Macro updates date & time when Word document is edited.
  192. issue with copying cells form one file to another
  193. error '13' type mismatch
  194. Can it work for say 10 pictures on 1 sheet?
  195. Update cells
  196. Issue with SUMIF
  197. Form listbox query
  198. Auto Currency Convert
  199. search rows to find elem stord in a dynm array
  200. Option Button Code is not working
  201. Auto Filter and sheet protection
  202. Repetitive colour highlighting
  203. Move Row to Sheet based on Column
  204. Programming Option Buttons
  205. Validation - List
  206. Lookup function
  207. Problem with ComboBox
  208. Copying a certain area
  209. Linking to a named Range in another workbook
  210. Pivot Table
  211. Set a cell to be at top left of screen?
  212. Average of times which are in dd:hh:mm format
  213. Improving the AutoComplete Function?
  214. Combo/List list walkthorugh
  215. Pivot Table Variable SourceType/Data
  216. Code -"Exit" routine
  217. Spin Buttons - Linked Cell to update when copied?
  218. Calendar issue
  219. Where to position Else
  220. Macro - copy values
  221. Macro - Collect data - Select folder and loop through all xls files
  222. Overriding Ctrl-V (Paste)
  223. Deleting Range Names
  224. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
  225. Using the Activate event to hide/unhide based on IF tests
  226. Macro to hide a sheet if a value on that sheet is 0
  227. XML exporting and XSLT
  228. Create new worksheets
  229. macro not being saved
  230. Activating a sheet whose name is similar
  231. consecutive value occurance count?
  232. Message box type
  233. highlight match's without conditional formatting?
  234. macro for mail merge
  235. Finding Excel version using Excel 4.0 Macro.
  236. VBA macro to select and copy data
  237. Macro - copy weekly data to a week number
  238. Export data from a SAP specific table
  239. Copy Worksheet for another Workbook
  240. Excel "Search Machine"
  241. index?
  242. preventing data in hidden columns from being deleted
  243. commandbutton to run solver?
  244. Code too long? Error 1004
  245. on open, write to text file?
  246. Variable into Currency?
  247. how to count on every occurence
  248. Formulating number difference
  249. Calculating a date based on code in cell
  250. Msg Box with User Input?