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. automatic graph creation
  2. does sorting based on a large filter list require a macro?
  3. Menus from macros using Excel 2003_Is it Possible?
  4. learning VB for Excel
  5. create a button event
  6. Reusing server connection
  7. Creating a matching list?
  8. Excel Protection
  9. Working with dimensions
  10. Multiple if
  11. Suppress Run-time error 13
  12. Countif using an indirect in the criteria
  13. Error trap in my code
  14. comparing csv files using macro
  15. change directory not working right
  16. Transfering row to other worksheet
  17. Matching / consolidatiing custom reports?? Please help
  18. Macros to Generate text
  19. Excel Games..who has them
  20. Maniupulating individual cells?
  21. Combobox in Userform
  22. How do I filter out data
  23. Size calculations and assignment
  24. Using a Cell's Contents to Find the Name of Another Sheet Within The Same Workbook
  25. Search array
  26. Coordinated in pivot table
  27. Correctly parsing a CSV file
  28. onkey Move to certain cell when i press tab
  29. Hide/unhide column with the value of other sheet
  30. averaging time stamped data chuncks at regular row intervals
  31. Copying a cell, including mixed formatting
  32. Automated Macro - Transpose
  33. Error when opening workbook
  34. UDF using SQRT function
  35. Copying certain rows from one tab into another
  36. Sorting Using VBA
  37. Quotes in a formula
  38. How to refer to array variable in vba?
  39. Changing fonts Macro
  40. pivottables: renamed fields and renamed data
  41. Itemized shopping list
  42. User Function Questions
  43. Type in letter and list pops up
  44. Function ranges issue.
  45. Using A Macro to Sort based upon a cell value
  46. exact search string type question
  47. vb to exe?
  48. Count number of occurences in a range
  49. Excel marco not working outside USA
  50. How to Merge Selection of Cells "Individually"?
  51. Only show once macro
  52. Select last cell before blank, then offset
  53. Deleting with a Macro
  54. Locked - Reason Title >> (Another)
  55. send email by checkbox selection
  56. How to change the value of a cell in every 20th row
  57. sumif with 2 criteria
  58. Deleting rows with blank value or "0"
  59. Variable Userforms
  60. Macro command to move cursor down
  61. Scatter Graphs and Labels
  62. Charts/Plots on multiple worksheets
  63. I've lost my VBA password - need to crack it
  64. Sumif, indirect and average?
  65. Open workbook in a new session
  66. ComboBox Change
  67. New data in different color
  68. Macro to copy cells from 1 workbook to another
  69. VBA to hide/unhide column with respect to a cell value
  70. userform calculations in textbox
  71. creating graphs via vb
  72. list box macro
  73. Adding Multiple To 'insert Pic' Code
  74. array for highest value
  75. Networkdays function
  76. Problem defining -some- variables in an IF statement
  77. How to locate a Cell and enter data using Combo and Text box Data!
  78. Looking for a Record Match with a Macro
  79. Countdown timer
  80. Using loop to output compounded values
  81. Formula to split data across a number of cells
  82. Creating buttons automatically
  83. Code not wrapped - Macro thinks cells are not blank although they are
  84. PRoblems Define Dynamic Range
  85. Display filename only
  86. What does ScreenUpdating
  87. Email subject line in VBA using Sendmail
  88. Make this code column specific?
  89. Excel Search column a and b
  90. Populating bulleted list in word.
  91. Calls Attended
  92. Macro
  93. Guidance appreciated
  94. Exclude certain cells fromConflicting Changes
  95. Macro inexplicably stops after Workbooks.Open
  96. Changing Ranges in VBA
  97. read cell content and use with Hyperlinks.Add Cell
  98. UK Map Chart
  99. issue with sending mail thru xls
  100. This should be easy for Excel gurus..
  101. Creating macro from visual studio
  102. onchange question
  103. Recall image by image address in cell
  104. Macro for change in cells
  105. Writing Multi-Dimensional Array To Range
  106. Random Number Generator
  107. Keep getting errors on a macro
  108. Date capture in Entry Form to Data Table
  109. Sheets to web VBA
  110. Breakpoints Ignored
  111. Macro Problem!!
  112. Comparing Two Graded Scores With "distinction" etc
  113. modifying a macro
  114. Macro to Active and backup spreadsheet
  115. Relate 2 Tables in Excel Database
  116. Pivot Table with ADO
  117. Pivot Table Calculated Field
  118. Adding sheets and renaming.
  119. Redeclaring array of classes during RT
  120. Vba Code Executes After Copying Sheet
  121. Macro for Moving Data
  122. A better way?
  123. understanding a cell value
  124. next row
  125. Select Multiple Sheets In A Vb Code
  126. A dll call in vba makes excel bug ???
  127. VB code to Reduce Font Size
  128. Increment macro
  129. Only follow formulas with values???
  130. Copying sheet protections?
  131. Conditional value, then other value is negative
  132. Creating new sheets from master list with VBA
  133. Hide Row Column Headers
  134. Printing Multiple Sheets to One PDF file
  135. save to pdf
  136. Formulas are showing
  137. xlDialogOpen.Show with password
  138. Permutations of a list (groups of 3)
  139. When a macro runs
  140. Multipage Pages
  141. Linking Returns
  142. Find last row and use in range
  143. Filling cells with text in them based on a seperate source worksheet
  144. Opening form to show the progress status
  145. use of grouped cells
  146. Delete rows which contain x and -x in amount column
  147. User-ID & PSWD from Macro for a Query Refresh
  148. Excel limitation on number of imported image objects?
  149. next row
  150. Delete Duplicates in Same column
  151. Create folder structure from Excel
  152. Problem IF statement
  153. Conditional formatting - color change
  154. How do you view the underlying formula of a cell
  155. problem accessing lookup list from sheet in another workbook
  156. controls to access a database in a UserForm
  157. Textboxes that are locked for editing
  158. Ranges
  159. Date difference in yyyy mm dd format
  160. counter in invoice worksheet
  161. New to writing macros
  162. Excel Macro problem
  163. value of the name box
  164. Macro to use MATCH, INDEX, or INDIRECT
  165. MultiSelect Listbox get/use Values
  166. How might one "save" a PSWD in a macro temporarily.
  167. auto running a macro when a cell value changes
  168. Calculate all reports(sheets) in a workbook?
  169. Export data to Word
  170. excelmedic
  171. Progress meter
  172. Problem copying VBA to diff sized ranges
  173. Can an "IF" statement be used in a Printing Macro?
  174. Vlookup formula in a cell
  175. Need Help On Dropdown Box Please
  176. VB code request for a Working Recorded Macro
  177. Macro to insert formatted row
  178. Solution to auto create labels for chosen rows?
  179. Emailing a wsheet after some code completes
  180. Increment cell value depending on input elsewhere
  181. Breaking up a long list into different worksheets
  182. How to turn off a warning messages and hide all activities from the user
  183. Help!!!!!
  184. Opening seperate sheet in wb in new window in predefined zoom
  185. Trouble when saving as a .csv file
  186. VBA array how to?
  187. Creating tables in Excel 2007 using vb.net
  188. Call Function by Name
  189. Row removal where cell value is greater than reference cells
  190. Loop Help
  191. Copy rows from sheet one to other sheets
  192. Importing specific data from CSV using macro
  193. how to reverse what a macro does
  194. Unprotect Workbook VBA code
  195. insert 1 empty row after 100 rows
  196. combobox in a user form
  197. Get User Name - Active Directory
  198. Random text not quite random
  199. VBA Source Control Add-In.
  200. Execute a macros every 5 seconds
  201. Macro copying row not working
  202. Count Cells That Do'nt Contain A Specified String
  203. Data Manipulation
  204. Problems with OLEObject Naming
  205. Deleting Entire Rows Containing a Specific Value
  206. Populate Dropdown Box From Closed Workbook
  207. Email format as Rich Text
  208. working with multiple data variables
  209. Menu Customization (Need Modular)
  210. Please Assist with Combo/List Box selection search
  211. Double IF Statements
  212. Macro - Warning before running
  213. VBA / Macro / Vlookup?
  214. Using a macro to apply conditional formatting to multiple columns
  215. code for ComboBox
  216. Can Excel access webbased stuff automatically using VBA?
  217. Insert url before text
  218. insert text in columns based on maximum number of rows containg data
  219. Macro to compose email from two worksheets based on conditions
  220. Excel Help a few questions
  221. Need a Macro to compare a value within a range.
  222. Calling a private sub
  223. VBA code to check font color
  224. filtering and conditional copy/paste
  225. Run all Macros
  226. creating a results register/database
  227. How to search through and pick out
  228. Automate Database Query Password
  229. Frezee Header and column
  230. Using VBA for conditional formatting
  231. Formatting cells based on content
  232. Save Macro Problem (Digital Signature)
  233. Adding a notification box when conditions are met in Excel
  234. Repeated values in table
  235. Replaying a pivot table in a macro
  236. marking and counting only what I need
  237. "Begins with" in a SUMPRODUCT
  238. Update Values in Userform when filter is changed
  239. Retrieve strings from text file
  240. assigning a digital signature with a macro button
  241. Hyperlink from drop-down menu
  242. smoth out "missing libraries" in VBA
  243. Define a range
  244. Filtered Data in usersform.
  245. Excel Picture Database
  246. looking for: sample workbooks to illustrate best practices or useful techniques
  247. Web query on .aspx pages
  248. Errors-I dont understand why
  249. Date Picker
  250. Flashing or Scrolling Text