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. Cell Change
  2. Excel 97 ADODB Recordset.Find "Invalid Use" error
  3. Cell Change
  4. Excel 2002 VBA connection to Access 2002 using SQL
  5. fso.FileExists is too fussy
  6. One works - One does not?
  7. Detect Password Protection
  8. Re: Change the File Open option in Excel
  9. Protecting my macros from being viewed/edited?
  10. NEGATIVE HOURS (2)
  11. Re: Extracting a dynamic range
  12. Change back round color of a cell w/VB
  13. Newbie- Filename referencing in macros
  14. formula help
  15. Application level event handler broken in 2003SP1 ?
  16. Can't browze and open file, urgent!
  17. Re: Populate Listbox with File Name Only
  18. How to?
  19. Re: Creating directories from excel
  20. How to?
  21. How to?
  22. SelectionChange or Defined Name Selection Difference
  23. Re: Populate Listbox with File Name Only
  24. can't do Find or Replace while Modeless form is shown
  25. Change back round color of a cell w/VB
  26. Automated charting VB code problem
  27. arrays in arrays
  28. "Last modified by" in a cell.
  29. Options in Cell
  30. Querying data from an outside table
  31. Errors on other PCs
  32. Excel.......Automate importing multiple changing CSV's
  33. Errors on other PCs
  34. Options in Cell
  35. Forms
  36. Re: Nested function 'FIND(OR)'
  37. Re: How do I use tabs in a macro?
  38. Re: How do I use tabs in a macro?
  39. Saving txt files and date format changes
  40. Master List
  41. Directory contents
  42. Offset Between?
  43. Cut cells from column A that contain "/" Paste them to column B
  44. Use Keyboard with Command Button
  45. Copy/Paste Macro and Column Sizing
  46. VBA Form Drop Down List
  47. msg box while operation is running.
  48. macro to update page footer number
  49. Re: How do I use tabs in a macro?
  50. Re: Creating directories from excel
  51. How do I use tabs in a macro?
  52. Re: XLDialog Printer Setup
  53. Installing Add-in for all users in Win 2000/XP
  54. Copying a chart
  55. macro question
  56. Save files as different names
  57. Linking userform to userform in Excel 2003
  58. Macro it's very Slow ....
  59. Auto create unique accelerators for a list
  60. macro advice
  61. Formatting all worksheets to fit on one page each
  62. UDF not available
  63. Make more than 1 selection from combobox send to another sheet
  64. Running Macro from objApp Application object
  65. Copy data
  66. Re: Setting MultiPage page default???
  67. Re: vbOKCancel -- Cancel doesn't work??
  68. Missing something? does not count correctly
  69. DateAdd
  70. Step Thru Formulas Macro
  71. Excel Question
  72. Macro to open another workbook
  73. Problems opening a text file using macro!
  74. add-ins
  75. Import PDF
  76. MsgBox Prompt w/ No "X" to close
  77. really simple question
  78. Copy data---never mind got it
  79. Excel 2000: How to execute code automatically?
  80. Re: Running a Macro from hidden Workbook
  81. Re: Excel - Customize Default Color Palette
  82. Choosing a directory/file
  83. Counting Values
  84. Re: Selecting a Range of cells in VBA
  85. Re: Question about opening workbooks on Excel startup
  86. Re: Referencing Code from another project
  87. Pointer required
  88. Re: Selecting a Range of cells in VBA
  89. Re: Question about opening workbooks on Excel startup
  90. Cell Naming and Formula bar Display
  91. Print area
  92. DO YOU NEED MONEY HE/SHE READS THIS I ARTICULATE???
  93. Qn: SpinButton1.Max not working??
  94. how do I delete a workbook
  95. Visit www.excelforums.com
  96. Re: writing a formula containing if and and
  97. VBA Code to switch view
  98. Checking if autofilter is on?
  99. Reading conditional format that is active in VB
  100. Initializing static variables in VBA
  101. How to optimize and improve that code ?
  102. Initializing static variables in VBA
  103. Counting Values
  104. where is the _IMsoDispObj
  105. peek and poke using vb
  106. Check cells in a column
  107. How to optimize and improve that code ?
  108. Re: Question about opening workbooks on Excel startup
  109. Re: Question about opening workbooks on Excel startup
  110. Re: Question about opening workbooks on Excel startup
  111. Re: SpinButton1.Max not working??
  112. Macro - Run automatically every X minutes
  113. how to connect to already open excel sheet
  114. almost works
  115. Vba - getting value from other userform
  116. just testing
  117. Excel VBA
  118. Re: Help with Reducing Numbers Please
  119. dynamic data lookup by cell
  120. Removing characters from a text string
  121. open word document
  122. Re: Histogram
  123. excel VBA
  124. Re: Hide VB Source Code
  125. Verifying lines with other workbook
  126. copy from a list
  127. press letter and go 2 entry begin w letter in data validation drop
  128. Re: Help with Reducing Numbers Please
  129. Programing Dialogs in Excel 2002
  130. Re: Help with Reducing Numbers Please
  131. Programing Dialogs in Excel 2002
  132. Please advise: excel's mathematic solutions
  133. Re: SpinButton1.Max not working??
  134. sending email from excel using outlook express
  135. auto run macro at workbook open
  136. making new wkb and place an event in it
  137. Re: Help with Reducing Numbers Please
  138. trouble linking formulas, because format continues to change
  139. Re: Find word and copy
  140. Re: SpinButton1.Max not working??
  141. Filter Listbox in user form
  142. new message scroll bar missing
  143. Is it possible?
  144. how to create a cumulative distribution
  145. Method 'Range' of Object_Worksheet Failed
  146. Re: Help with Reducing Numbers Please
  147. Can you Limit the number of caracters that can be typed in a cell?
  148. Re: Hide VB Source Code
  149. How to create the URL with link using the VBA form input in excel?
  150. checking if file is saved
  151. How can I create a URL with link using the VBA form.
  152. Is it possible to open the VBA form with a link in a sheet and to pass variable from a cel
  153. TEXT TO COLUMNS
  154. VBA macro to obtain file names using WIN32 API
  155. Re: Help with Reducing Numbers Please
  156. Clearing TextBoxes needs 2 clicks
  157. To reformat a culculated date/time round-up to the nearest ½ hour
  158. Lost Focus - Applying to cell
  159. Worksheet functions in VB
  160. how to add items to combobox
  161. matching dates from imported *.dbf file?
  162. can we add a blank line after every...lines?
  163. Re: Is it possible to open the VBA form with a link in a sheet and to pass variable from a
  164. worksheet function in VB
  165. Not sure how to handle this
  166. Re: To reformat a culculated date/time round-up to the nearest ½ hour
  167. Missing a library in menu --> extra -->references
  168. Re: To reformat a culculated date/time round-up to the nearest ½ hour
  169. Re: Help with Reducing Numbers Please
  170. Excel Macro Query - Search for specific text in cells of a column
  171. protection with password
  172. Sending Excel Data to a Coldfusion Form
  173. ListBox "picking the same item repeatedly"
  174. RE: mswinsck.ocx
  175. ActiveCell.Formula
  176. import simple data & re-arrange it
  177. pls help newbie with my significant figures function
  178. VBA, How to open a file with date like 29 August 2004
  179. Microsoft Office Word has encountered a problem when shutting down
  180. Re: Reading from an Excel Document
  181. RE: HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
  182. Resize Range Question
  183. more newbie help on my significant figures function...
  184. Protect worksheet
  185. File Open Take a Long Time
  186. Excel User Group, Sydney, Aus
  187. Read from an Excel file
  188. Help with my code and formula
  189. How to create controls at runtime
  190. Trim: Excel 97 gives error "Can't find project or library"
  191. Runs possible on the background?
  192. Calling Microsoft Excel ODBC Query
  193. Possible to write VBA code to send out an EMAIL everytime a workbook is opened?
  194. validation list from other sheet
  195. How do you get a check box to generate the current time?
  196. Generating currnt time from Window's logout?
  197. Re: Excel 97 gives error "Can't find project or library"
  198. Macro
  199. Mail from Excel 97 via Notes 5
  200. Selection.AutoFill Destination
  201. Re: Excel 97 gives error "Can't find project or library"
  202. Re: Excel 97 gives error "Can't find project or library"
  203. Re: Excel 97 gives error "Can't find project or library"
  204. Re: Excel 97 gives error "Can't find project or library"
  205. Re: Help with Reducing Numbers Please
  206. Selection based on coloured cells?
  207. Can I split&write data to each individual sheet?
  208. Re: Excel 97 gives error "Can't find project or library"
  209. Re: Excel 97 gives error "Can't find project or library"
  210. Re: Excel 97 gives error "Can't find project or library"
  211. Header/Left margin
  212. ComboBox
  213. GetSaveAsFilename - Save as box
  214. SpinButton Controls in Excel 2000
  215. Lookup external data by cell or range of cells
  216. Validating from a list workaround
  217. Macro
  218. Header/Left margin
  219. drawingobjects what is it ????
  220. Re: Excel 97 gives error "Can't find project or library"
  221. Need help with figuring running totals
  222. Little bit of Java in VB?
  223. Need macro that selects an item off pivot page filter, prints, se.
  224. ambiguous error
  225. Re: Help with Reducing Numbers Please
  226. Importing a txt file to a ComboBox itens
  227. ActiveCell.FormulaArray code - Get error
  228. Checking Cell Background Color
  229. Help with grouping values
  230. Newbie Help
  231. macro
  232. Rounding problem (controlling word from excel)
  233. Get Word to the foreground
  234. linking to web page
  235. Pasting in a unique row for each unique date
  236. Re: How do I open a Form in Excel XP
  237. Excel Functoin getting Cluster status
  238. Expanding Selection Range
  239. Adding a drop down list
  240. Re: Programming to VBE
  241. Macros not getting updated in personal.xls!
  242. Re: Selecting a Range of cells in VBA
  243. multiple cells in a loop
  244. Re: Programming to VBE
  245. Pivot Table Grouping
  246. Re: mkdir problem
  247. Referencing specific cell
  248. Re: Programming to VBE
  249. QN: Webpage Hyperlink in a UserForm??
  250. Macros not getting updated in personal.xls!
vBulletin v3.6.2, Copyright ©2000-2010, Jelsoft Enterprises Ltd.