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. Date field to fill with status for tools
  2. Check Boxes Hiding
  3. Dynamic Sort
  4. SaveAs Code
  5. Macro assistance
  6. Select methof of range class failed (1004)
  7. File Directory Open Events
  8. Copy selected data to a user defined destination
  9. Auto filter off code
  10. iteration formula
  11. Conditional formatting macro (highlight macro)
  12. Copy multiple sheets to new workbook
  13. how to protect a graph from modification
  14. How to consolidate all the excel tables into one table?
  15. Filter Problem
  16. Incorrect division by zero when using DLL function
  17. Macro that deletes specific graphic in sheet
  18. Deleting Duplicated Rows
  19. Background Code
  20. Locate max number from column A
  21. unsave the excel
  22. Double Clicking a Command Button
  23. Query complete sheet and copy to another sheet
  24. copy form
  25. Line Input for Linux generated files
  26. Change Event based on two other cell values
  27. Creating a graph from data
  28. Macros security level
  29. Copy/Paste Macro
  30. Combobox in userform
  31. ReDim Public Variable
  32. insert text in a textbox
  33. Saving Files
  34. how to Show Formula of one Cell in NEXT CELL
  35. Macro to generate forms from database
  36. How to attach a local file to email using macro?
  37. VB Code and Checkboxes
  38. Copy plain text info from excel to outlook document
  39. Using a text box as a text editor
  40. Excel cell check
  41. loading userform form open
  42. dropdown lists
  43. Hyperlink
  44. Action button sending to different sheets depending on selection
  45. Run Time error 1004
  46. how to open the workbook and add into workboooks collection
  47. VBA Code for Date and Day of Month
  48. Auto refresh data when spreadsheets is closed? excel or outlook?
  49. Database
  50. Insert data from Excel to Word
  51. country finder lookup macro
  52. cant fix bad record length error
  53. Textbox format
  54. Copy Cell with Color
  55. Tab issue with form textboxes
  56. Close then Go
  57. Macro that creates a formula
  58. passing a variable to Page Header
  59. select an object and change color
  60. Move image to range
  61. copy and paste special values
  62. Query a database from a range and output results in column next to range
  63. Automated removal of zeros from spreadsheet
  64. Query to Add Data from column
  65. Undefined number of parameters
  66. problems when WB1 closes WB2
  67. VBA - Selecting a cell based on relative position vs cell #
  68. first blank cell in a column
  69. workbook events
  70. Data filter with command button
  71. Counting by color index
  72. Focus on Multipage#
  73. Converting to Upper Case
  74. Leaving a control in its previous state
  75. (Un)Merge range in different worksheet
  76. Convert to MS access
  77. Runtime error 1004
  78. compare worksheets
  79. Streaming cell value into a form
  80. AutoFilter by Rows
  81. Excel Queries
  82. Events for pictures
  83. Insert Picture
  84. Find Minimim and Maximum Number
  85. Maintain the columns using macro...
  86. Inexplicable Redim error
  87. Creating a formula via VBA
  88. Pass Shapes property names into module
  89. Counting Sheets
  90. Macro that calls other macros in different sheets (Mudraker)
  91. Random Draw Question
  92. Weekly Sales Compare
  93. macro needs assigning on different machines
  94. Spinbutton
  95. workbooks.open stops the macro
  96. pivot table add rows
  97. Password to open sheet in workbook
  98. Numbers only in text box
  99. Shifting online data comes to excel to be shifted to adjacent cells as per formula
  100. Macro to Copy a value to an expence column
  101. pictures for buttons
  102. Data Validation=> List=> code for quickly finding data
  103. Macro that calls other macros in different sheets
  104. transfering of data
  105. shifting online data comes to excel as per formula with very minimum timelag
  106. Extract interior text formatting
  107. how to query mysql and get result into excel?
  108. Add a Number to add to next column
  109. loop
  110. Switching a message box on and off
  111. Finding Multiple Variables
  112. Isdate, Isnumeric, IsEmpty (but no Istime?)
  113. Change Row Color (8 criteria)
  114. copy data in to different columns
  115. Writing Data From Form to Cells in Worksheet
  116. Highlight differences using VBA
  117. Hiding rows where non contiguous cells are 0
  118. Update cell value macro
  119. textbox
  120. pivot table field list change from cell
  121. Copy range with pastespecial function
  122. Userform
  123. Choose and Use Open Workbook from Userform
  124. Printer dialogue box
  125. Display last record in Userform
  126. Macro to Hide/Unhide Worksheets
  127. Can VBA call a DOS command?
  128. Cell Referencing
  129. Excel ANOVA Two Factor with replication
  130. PasteSpecial Formulas Macro
  131. Hyperlink Search Macro
  132. Passing Variables between Modules
  133. Delete every other row
  134. Using Formula to activate a dropdown menu
  135. Disable Macros From Within VBA Code?
  136. Save as filename=(range("A1")
  137. Changing Network Printers
  138. Make Buttons workable on UserForm
  139. hide rows
  140. Copying only two decimals
  141. AfterRefresh
  142. Timestamp macro questions
  143. Increasing ActiveWorkbook.RefreshAll Performance for ODBC connection....
  144. Splitting Pages into Workbooks and filtering
  145. userform
  146. Having excel send e-mails automatically
  147. Looping the Find Function
  148. Automatating Validation List Selection
  149. Search with two parameters
  150. Email Formating
  151. Email from excel depending on data
  152. Dynamic Macro's
  153. creating a filename variable
  154. Put a currency format in word bookmark
  155. Sharing macros between workbooks?
  156. formatting subtotals
  157. excel cant connect to sql server
  158. Name workbook without saving in sendmail method
  159. reference specific cell in selected row
  160. if/or finding one letter in a cell
  161. Worksheet Protection when using VBA
  162. Calling a DLL from Excel.
  163. Find a country against code
  164. Delete Row Based On Cell Criteria
  165. form error
  166. Save not Saving
  167. sending mail only using excel
  168. AndIfs condition & dynamic ranges
  169. Textbox format
  170. inactive for 10 mins
  171. Using offset to select next empty cell
  172. reading data from CSV
  173. Excel Recordsets
  174. Basic UserForm
  175. Countifs
  176. index function, returning the column values
  177. Linking Multiple XLAs
  178. disabling MS Shortcuts
  179. basic macro for ODBC connection
  180. Restricting the search to one column
  181. ODBC connection
  182. How can I overwrite cells
  183. vlookup i think
  184. Mouse over effect in excel sheet
  185. finding text in cells using Array
  186. Macro to pull data from 30 files
  187. macro code to identify fonts character by character
  188. Program not picking up cell value
  189. how to get data from saved workbook that is also currently open?
  190. Macro to show/hide worksheets
  191. Running Macro with Key Shortcut
  192. Macro To Insert Formula
  193. Merging 2 Worksheets Data?
  194. getting modules to talk to each other
  195. Array and count
  196. Product (multiplication of cells)
  197. Pivot table reformatting into word
  198. Auto Filter
  199. VBA Code
  200. Exclude some sheets
  201. lookup table
  202. update from textbox to text
  203. VBA Concatenate Solution needed
  204. Use an icon from a network drive for a desktop shortcut
  205. Excel time sheet
  206. Delete the whole row if any cell in that row contains certain text
  207. Deleting Blank Rows
  208. BuiltinDocumentProperties
  209. Copy Paste Transpose - Sort Of
  210. 2 input cells to populate a data column please?
  211. Dynamically create variables based on sheet data
  212. Simulated phone display
  213. copy cell down
  214. search macro
  215. convert a number into two seperate numbers in two different cells.
  216. userforms
  217. Need some macro help.
  218. input box
  219. delete rows when cell is blank
  220. Can I use WHERE SOMETHING>0 on an SQL currency field (using VBA)?
  221. Simple Copy/Paste Macro???
  222. Writing a program with changing variables. . .
  223. Deleting objects within a certain range
  224. Connecting Excel with access 2007
  225. Generating graphs automatically
  226. Paste Values Macro
  227. How do develop a soccer scorebook stat program
  228. Respond to a clipboard dialogue box with vba
  229. Save values on specific worksheet
  230. Generating graphs
  231. Select Last Cell - Blanks in between
  232. deleting duplicate cells
  233. copy row
  234. info from form to excel
  235. from one sheet to another
  236. Moving all but the newest files from one folder to an Archive folder.
  237. Concatenate text on a selection of cells
  238. Using a Macro to find Chart
  239. Transform Data from A1,b1,C1 to A50,A51,A52
  240. Clearing Userforms
  241. Delete Row macro
  242. Command Button with a twist
  243. Opening a workbook from a cell condition
  244. auto update pivot table and/or filters when data changes?
  245. Opening a User Form
  246. Sent e-mails via vba excel
  247. Selecting All Buttons
  248. Generate Graph Automatically
  249. Looking for UserForm textbox with scrolling
  250. Increase vertical spacing in a listbox