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 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399

  1. Adding functionality - Deleting row in Named region from ListBox selection.
  2. Activating a Worksheet with a changing name
  3. Create cmd button on spreadsheet to run Macro
  4. error on excel.exe
  5. VBA test for circular reference
  6. Create cmd button on spreadsheet to run Macro
  7. pivot table vb code - how do I restrict access to dropdown box?
  8. app events and drag-drop
  9. CopyFromRecordset Bug with Office XP
  10. Adding functionality - Deleting row in Named region from ListBox selection.
  11. Problem: Checkbox moving after Print Preview
  12. Update DBF (Re Post)
  13. VBA for hiding row & column headers
  14. Erratic Sort in Excel 97
  15. Sending an e-mail
  16. Cannot Paste a 16x16 Picture into Excel
  17. Pasting picture in Excel increases size (Pasteface, Custom Button)
  18. Help Plese.
  19. Prevent user selecting cells
  20. preventing access to the vba code in an excel workbook?
  21. values of an interval of cells HELP ME
  22. Printing question
  23. Reading data from word tables to excel
  24. Shorter code
  25. Finding last column
  26. How to suppress the Outlook Security Warning Screen?
  27. VBA - compare cell against column in diff sheets
  28. How to detect and delete empty rows in a list?
  29. delete row
  30. External Workbook Help!
  31. Extracting data from a chart
  32. How to automatically add Toolbar buttons and run add-in?
  33. Macro Fails in Worksheet
  34. Lookup in multiplesheets
  35. Changing Checbox Values on UserForms
  36. Last row
  37. macros not firing: XL '97 vs XL 2000 vs XL 2002
  38. Last row
  39. 16bit number split into bits
  40. Change from Check box to Option button
  41. Excel VBA - create worksheets/dynamic range names problem
  42. Copy with Advance Filter
  43. Transposing cells & deleting sheets
  44. SendKeys question?
  45. Compare two strings with same characters, but different order.
  46. Customised Toolbar with Macro buttons
  47. Replace text string
  48. Range veranderd bij knippen en plakken
  49. to:Bob Phillips- don't answer if u don't know what ur talking about!
  50. Re: to:Bob Phillips- don't answer if u don't know what ur talking
  51. Have pulled out the last hair on my head
  52. Trying to get data from SQL Server (MSDE) database with Excel 97
  53. Solver in VBA
  54. 回覆: Re: How to suppress the Outl
  55. How to make Excel 2002 to automatically update worksheet names in hyperlinks?
  56. convert string to date
  57. Expanding the Name Box
  58. Macro to password protect several excel files in same folder
  59. Copy to Clipboard Questions
  60. Passing arguments in gosub routines
  61. VLookup - which cell am I looking at?
  62. Excel Project and Libraries
  63. FormulaArray question in VBA
  64. Fractions of a Second Problem
  65. Not thisworkbook, but the other one...
  66. How to position at the end of inserted pictures?
  67. Overloading builtin macros
  68. how to check is catalogue exists
  69. Have pulled out the last hair on my head
  70. VBA 'Newb' - Output to one FreeFile on multiple events?
  71. Dynamic Chart Scale
  72. Workbook not opening
  73. Protection
  74. Re: Compare two strings with same characters...MY APOLOGIES
  75. Time example
  76. SUMPRODUCT in VBA... conditional sum
  77. how to link workbook to invoice?
  78. Which Object Library for Office 97..? 5.0 or 8.0?
  79. If function
  80. Getting #REF error on copy/pasted cells with macro!
  81. Merge Workbooks
  82. Workbook not opening
  83. howto use range variables in functions
  84. Create Live Cell Reference
  85. Transpose
  86. Userforms
  87. Linking between workbooks..
  88. Re: Rejected Safe Mode action : Microsoft Excel.
  89. SYTAX problems
  90. Have pulled out the last hair on my head
  91. Fill empty or blank cells in selection with a prompted value - an example
  92. On workbook open
  93. SYTAX problems
  94. Saving to Network share with different mappings?
  95. Not very efficient
  96. autofilter/programming?
  97. Error Handling
  98. howto use range variables in functions
  99. Re: How to delete all graphical objects in a sheet
  100. Public/Private
  101. Why Excel plotter doesn't accept zero's row?
  102. Disable Ctrl and/or Alt Key
  103. FileExists filename wildcards
  104. Clarification
  105. Text box for password
  106. Starting Dialog Box using Macro
  107. VBA question please
  108. UsedRange/Copy Columns question
  109. Using Cell Value to Determine Which Macro To Run
  110. Links between word and excel
  111. "Save As" macro
  112. Using VLOOKUP in VBA
  113. writing array code
  114. "Save As" macro
  115. Protect code/cells using Function/DLL??
  116. Don't save changes when user closes WB
  117. Problems Opening Workbook after running macro
  118. Excel Menus Removed
  119. Excel 2003- "File Error" data may be lost
  120. List boxes
  121. Refreshing Data Query
  122. Userform Cell Link
  123. Automatic Currency Exchange Macro
  124. Chosing from a Calendar
  125. Displaying different ordered items under the same order.
  126. URGENT WARNING: CIHOST.COM - TERRIBLE SERVICE - DON'T USE THEM
  127. USERFORM: default possition?
  128. Eliminating a Warning MsgBox
  129. Closing Excel
  130. Hidden Cells in formulas
  131. Calling a userform
  132. Couple of VBA Questions
  133. Running a MS Project Macro in Excel
  134. Hide/Unhide Rows based on ComboBox
  135. Old topic, new post
  136. how to check if Worksheets(x) exist?
  137. Opening a CSV text file using OpenText function from an MFC application fails
  138. VBA: Setting the color of borders of cells
  139. USERFORM: static
  140. VBA: How do I switch to landscape?
  141. Sort calculated field in a pivot table - an example
  142. Re: How do I switch to landscape?
  143. VBA run at upon opening
  144. Help with cell formula, please...
  145. A big thank you
  146. Re: How to make Excel 2002 to automatically update worksheet names in
  147. Excel VBA Problem
  148. relative cell reference in a VBA macro
  149. showing a Userform from another workbook
  150. Re: Setting the color of borders of cells
  151. look up and input
  152. Edit/Replace that preserves in-cell formatting.
  153. VBA Summations
  154. Need Help with Next thing
  155. Excel macro error when opened in internet browser
  156. calendar picker
  157. Worksheet_Change
  158. Reducing text beyond =left or =right?
  159. 12 Conditional Formats based on Dates
  160. Doble click a cell and running a macro
  161. Shortcut Key
  162. Selecting a Time in a cell w/out inputting the data
  163. Re: Group counting
  164. group counting
  165. Name a new Sheet but delete if it exists first
  166. Converting many lists into one
  167. Excel / Windows XP question
  168. Excel SDK: Select a blank cell
  169. Find several names at a time
  170. links
  171. Parsing based on content
  172. Get optionbutton status
  173. Help with Modification of code
  174. SQL Query Without Worksheet Object
  175. Replace command that preserves in-cell formatting.
  176. code doesn't work
  177. Disable Zoom
  178. Code Modification
  179. user form deactivation
  180. Any sample/tutorial VB6 excel COM-Add-in?
  181. Error In Code??
  182. How can I conditionally select multiple rows to be moved with vba?
  183. NONE
  184. Exporting sheet as text without modifying workbook
  185. Calculate cell formula changed by VB
  186. Error 1004 ...
  187. Show Picture in a pop up message box in excel 2000
  188. Day and Date Validation
  189. additional question
  190. Macro
  191. Event Study with Excel?
  192. COPY/PASTE NON-ADJACENT COLUMNS
  193. Remove code module automatically
  194. reformating merged cells in a protected sheet
  195. Crashed Excel File
  196. chartobject
  197. Test to see how many worksheets are open and closing active worksheet
  198. Drop Down List
  199. Slow code execution when Excel 2000 is in the background
  200. Showing a userform
  201. Printing a file from Windows Explorer using VBA in Excel
  202. simple code
  203. 回覆: Re: How to suppress the Outl
  204. Getting code/button to run/execute
  205. How to select some sheets to print with VBA (Based on a user's choice)
  206. Datavalidation - dropdown
  207. Saving lots of files to different locations
  208. Code for Multiple Workbooks
  209. creating dynamic ranges and charts
  210. No data was selected to Parse Error
  211. deleting Macros en masse
  212. sumif from an array
  213. Showing a userform
  214. Excel 97 popups
  215. View Access Reports in Excel
  216. Calendar
  217. macro runs very slowly
  218. how to disable a macro by calling it from another macro
  219. #ERROR Trapping
  220. Auto format textbox as mm/dd/yyyy
  221. Format year problem
  222. new line
  223. Format year problem
  224. chartobject
  225. Margins ' Default ' settings
  226. COUNTIF help
  227. Disable WorkSheets Change
  228. refering to a workbook
  229. For ...Next loop help please
  230. VBA newbie - How to make active cell frame invisible?
  231. Re: Hide Empty Rows.
  232. Format year problem
  233. ActiveX Check Box Question
  234. How would I do this? Updating one worksheet from another...
  235. Return To Home
  236. remove header from userform?[blue bar @ top]
  237. Change Event is looping indefinitely!
  238. Summations
  239. delete entire row if present a difference....
  240. Protection and hidden
  241. Find Total but not Grand Total
  242. Change Event is looping indefinitely!
  243. Disabling Excel functions
  244. Code modification
  245. Error 55- file already open
  246. Recent Microsoft Excel Updates - March 24, 2004
  247. Count function
  248. Insert new row after every other row procedure - an example
  249. Trap Close event at worksheet level?
  250. Re: Convert to text
vBulletin v3.6.2, Copyright ©2000-2010, Jelsoft Enterprises Ltd.