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. error message problem
  2. Hiding a Tab
  3. Modify dropdown menu on right-click
  4. Reading Text Files Into Excel (.Read) and Searching Them
  5. Deleting an image
  6. Link macro to cell then on key procedure
  7. Macro to move Cells like a GUI
  8. Loading userform
  9. Matching a cell ref. in a macro
  10. Excel Spreadsheet with notification when due date arrives
  11. Code that checks the language setting of Win
  12. Error On Line 13
  13. Macro to Fill Blank Cells
  14. drawing in excel
  15. Move Cell Contents like webpage
  16. Disabling Close on Userform
  17. Columns of data ... need a macro that can find differences of 0.06 & Fill Color them
  18. Move a cell which in turn moves a folder?
  19. Macro To Add Rows in Excel
  20. How to temporarily hide a form?
  21. log staff's flexi times
  22. Macro crash when range selected
  23. Yes or No Button for multiple functions?
  24. Problem with Query refresh
  25. inserting images into a form
  26. Range object drops it's value
  27. How to make a macro work in a row but not on a certain cell
  28. Macro for printing selected information
  29. 30 excel files, two cells to import!
  30. Auto fill macro question
  31. Choose database
  32. Excel argument selection mode
  33. Workbook before close event
  34. How to de-select pasted cells?
  35. Compare dates VBA problem
  36. Range - Userdefined Property
  37. Excel VBA Printing Footers
  38. Automatic Autofilter
  39. Countif in VBA
  40. add a button
  41. Worksheet Macro
  42. Sort Function
  43. Adding items to another sheet
  44. Combo box populating from sheet
  45. Header Macro with a list box
  46. Deleting rows based on fixed criteria
  47. Macro or VB code for importing data in excel...imp
  48. Convert Excel to clean HTML
  49. Start automatically a mcro depending on the value in the cell
  50. Creating a staffing board for work
  51. Autofilter
  52. SQL-database kiezen
  53. RowSource Not Working
  54. UserForm Textbox Question
  55. using RowSource property but nothing appear in Combo box
  56. inputting multiple data with different formats into the same cells
  57. VBA Code
  58. Prompt to select a cell and return its range
  59. Executing Winzip from within the Workbook
  60. Copy/Paste Function...
  61. Having a number automatically going to another sheet
  62. Pivot Table question
  63. Automatic averages
  64. Having one cell automatically conveting another
  65. Combo box? Data Validation?
  66. cant upload xls sheet
  67. Macro to rename and move files
  68. Pop up pictures!
  69. COUNTIF does not support 3 dimensional referencing
  70. automatically insert new rows
  71. Making a list that relates the first and last number of a range
  72. macro to remove conditional formatting
  73. Copy/Paste Macro
  74. If function
  75. Linking text boxes in UserForm
  76. Msgbox - when cell is empty
  77. Intelligent Sort function
  78. select all rows with data in column j
  79. Preventing import code from stopping when it can't find a file
  80. Cut username from a cell with a function
  81. Soccer Help
  82. simple range selection query
  83. validation code
  84. Hiding Rows
  85. Deleting Rows based on cell content
  86. Launch macro on single click with toggle
  87. Renaming JPG images
  88. Runtime Error 1004
  89. Sumif ??
  90. Exclude Weekends in formulas involving dates
  91. Indexing Axes -- a new but related problem
  92. Add to Visual Basic Combo box through excel
  93. macro for searching web
  94. Time Dependent Operations (Yowzah!)
  95. Insert a formula with relative cell reference based on a number in a column
  96. Finding Label/Symbol of Biggest Value in an Array
  97. sum data in a different worksheet
  98. VBA: Using a textbox to search a worksheet
  99. Subtraction macro request ...
  100. Macro for cut and paste worksheets
  101. Multiple Column In List Box
  102. Getting Data From User And Storing Into Array
  103. Column Sort using VBA
  104. Copy, paste down column
  105. Copy to another workbook
  106. Private subprocedure limitations?
  107. Retreive a name from a list if an specific name is in a cell
  108. If a cell contains a certain string
  109. how to call a Private Sub ?
  110. Duplicates cells - multiple - need last 3
  111. macro to refresh database everytime excel is opened
  112. Check/Uncheck all checkboxes
  113. parsing huge list to take out values
  114. Error when formatting date...not sure why
  115. Type Mismatch Error on Find Closest Match
  116. Sum formula in a macro that will sum data horizontinally
  117. Save As Name Macro
  118. if-statement regarding decimals
  119. Selecting a Cell using Find
  120. removing the first 3 characters
  121. Selected cell macro
  122. VBA of charting last months dynamically
  123. compare worksheets
  124. Confirming the completion of Batch files in VBA
  125. Max value if condition lookup
  126. macro for conditional cell merging
  127. Using ThisWorkbook for code efficiency
  128. Splash Screen
  129. Quick Question About Declaring Arrays
  130. New to Excel VBA... question about changing active worksheet in subprocedure
  131. Run-time error '1004' Move Method of Chart class failed
  132. Create a shortcut to the desktop in a macro
  133. combo boxes options be linked to worksheet?
  134. Complicated If Then Worksheet_Change
  135. Automatically update cell value that is created by a formula for use in a Case Stmnt
  136. Force Auto Fill
  137. Wrap A Text In Textbox
  138. Right/Left click Properties of Cells
  139. Is this possible in EXCEL with VB
  140. So simple userform query....but still can't do it!!
  141. Filename Problem
  142. Change Event doesn't change until I return to the Target Cell
  143. create multiple workbooks based on data in worksheet
  144. Modify Date and Time
  145. copy parameter of Polynomial Trendline
  146. Application.WorksheetFunction.WorkDay
  147. Counting External Links to Spreadhseets
  148. Finding Comments
  149. Add-ins Issues
  150. VBA calculation for Pivot table
  151. Optimisation problems (beyond Solver)
  152. Add-Ins
  153. Close Excel if macros not enabled
  154. can a userform be linked to another userform?
  155. Empty column
  156. Preventing users from selecting a cell in a range
  157. Is Combobox a vb 6.0 type?
  158. Userform autofilter visible rows
  159. Moving images on form
  160. Copy Cell In Adjacent Worksheet To Same Cell In Active Worksheet
  161. Paste Special & Values
  162. Reorganisation of data
  163. add worksheet in custom function
  164. Ru-Time error '1004': Macro
  165. add a lot of images to sheet
  166. Compile errors
  167. Calling a Macro from a cell
  168. Variable doesn't work based on type
  169. Compatibility Issues with VBA 2000 & 2003
  170. move decimal
  171. Autofit if characters in cell exceed column width
  172. Excel 2007 VisualBasic (Userform)
  173. naming a worksheet using a cell value
  174. Naming labels on Input Form problem
  175. Pivot-Table Auto Update Macro
  176. changing name of range
  177. Copy from 1st workbook and paste to 2nd workbook
  178. delete duplicate records after totaling a field from each record
  179. Macro with a few prompts for input
  180. increamentally searchable ComboBox with very large list
  181. how to run macro after a check
  182. call macro using button
  183. Conditional formatting Macro
  184. Macro a Hyperlink
  185. macro to paste around cell entry
  186. VLOOKUP with multiple pages
  187. Excel automatically adding single quotes to a named range
  188. hiding a few rows with a macro takes forever
  189. Emailing worksheet accessed from a website???
  190. Excel Crashes when saving after running Userform
  191. loop through all sheets in a list
  192. database to group
  193. Restrict values on columns
  194. Cell Comments - not going into edit mode
  195. Auto start functions and macros
  196. Tax Computation
  197. Unable to select a cell on a worksheet
  198. .CodeName inconsistency
  199. Defining a Range using a variable
  200. Combo Box Tweaking
  201. Run-time error 6 : overflow
  202. command to get the cursor to drop to the next line
  203. Command button?
  204. Odd behaviour from MsgBox
  205. Excel 2007 Userform
  206. Locking "Total" row of Excel table
  207. VBA in word
  208. VBA to save CSV file as XLS, delete CSV
  209. Get macro to run on next active cell
  210. Passing parameters to a subroutine in a different workbook
  211. Create Backup File Within A Macro
  212. Using find function to find entries in multiple cells
  213. Using VBA to add a value to shape
  214. Control position of message box?
  215. vba moving userform to database
  216. Querying for a cell
  217. simple, stubborn user-defined function
  218. Listboxes and resulting data
  219. Turning Edit in a cell off
  220. Passing parameters to OK button in a form
  221. Setting the integers in Range() into variables
  222. dropdown box options
  223. Fill series when filters on
  224. If and Trim conditional
  225. Locating corresponding cells in another worksheet
  226. Round to 50 or 100
  227. Correct syntax
  228. How to close an excel workbook opened in IE?
  229. Displaying an Array
  230. Translating multiple Pivot tables
  231. Set error cells = 0
  232. Storing a range of values
  233. Trouble with If Then Else statement
  234. Data Transfer
  235. Search and display in a form, edit, and save to spreadsheet?
  236. Cannot insert remote .jpgs from remote site
  237. VBA code to check for missing reference.
  238. Complicated VBA Question
  239. Generating graphs from multiple groups of data by vba
  240. Multi Column ComboBox
  241. Trying to get this Macro to repeat on all rows, not just the first one
  242. Run macro on cell change
  243. Updating Defined Names with Macro
  244. Setting Number of Words
  245. importing data into new spreadsheet.
  246. Fill empty cells in Excel with something
  247. Scroll Bars In VBA User Forms????
  248. Macro to Copy Contents of Cell Right 1 Down 1
  249. Slow Timer
  250. Tab Title Macro