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. VBA Macro with user msgbox
  2. If a cell contains "A1-B2", copy a related range
  3. Sending binary outputs to USB port.
  4. Remove custom menubars
  5. Resetting or Changing Active Directory
  6. Excel FrontEnd - Access DataSource Example Needed
  7. Check value of cell, and delete row
  8. Eliminating Save Dialog but still Saving Excel File
  9. Delete rows based on criteria vb modification
  10. How to activate a macro from combo box / list box
  11. Selecting only cells of a certain colour (CF)
  12. Filter Alphanumeric filename in GetOpenFilename
  13. Back up Excel Files
  14. ===How to Col_index_num in Vlookup===
  15. Extract info from Advantage Database Tables
  16. DDE Data Exchange
  17. Establishing A Time Interal
  18. Copying cells till blank rows end
  19. Zoom size adaption
  20. Run-time Error 9 with Excel macro - Runs in 2003, Fails in 2007
  21. Append multiple workbooks with multiple worksheets
  22. Deleting blank rows using loop and SpecialCells
  23. Userform code
  24. Macro error Excel 2003?
  25. macro (FOR loop and IF's)
  26. Exclude Blank cells when matching against other cells.
  27. Matching Data - Loop
  28. Loop for a large data set
  29. Help on a special vlookup
  30. Declaring Multi-Dimensional Array
  31. how do I get a userform to cancel my code
  32. copy files code (improvement needed )
  33. Adding new name if not found
  34. While... End While not working
  35. No results after autofilter
  36. Identifying Buttons
  37. Identify word from a cell
  38. Private sub not working correctly when called from another macro
  39. Breaking links between workbooks VB
  40. Referencing Decimal values in a function.
  41. Adding help comments when Creating a function
  42. Selecting Data that fits a criterion
  43. help needed linking to a cell to obtain date
  44. multiple data type validation
  45. Macro to paste shape in cell address - so close & yet...
  46. Amend code to run faster
  47. How to grab data corresponding to a lineitem?
  48. how fill a listbox or combobox when the user open the file?
  49. [SOLVED] Getting the Month out of the date
  50. Send excel cells automatically via Lotus Notes 7
  51. Automatically calculate and color rows/columns
  52. Intercept Menu Click
  53. Opening Excel Interop Attachments from Explorer
  54. Custom function slowing workbook speed
  55. how can i make A and B give the same reult as B and A
  56. Pausing for input
  57. comand button and userform
  58. Reverse lookup
  59. Open according worksheet
  60. Error in macro when no data is available
  61. if statement
  62. Macro Error
  63. New to VBA and Excel, need help splitting a name field and dumping extra middle names
  64. Add-In Problem
  65. Macro to format a new files. (this is hard to explain)
  66. Embedded calendar VBA code...
  67. Opening a database file
  68. looking for a date and returning associated data
  69. Copy and Paste Special Formats without the underlying Conditional Format Formulas
  70. Color banding or conditional formatting
  71. Creating new Macro using Save As
  72. Using Pictures to return numeric totals
  73. Creating a User Form with variable number of Controls buttons
  74. can I disable save but keep save as
  75. average of cells from user selected range of worksheets
  76. carrying over variables from userforms
  77. Workbook link/match text/auto input
  78. Speed up excel
  79. Hyperlink to open pdf files
  80. File Open with reference to a Cell
  81. Embedding BASIC Routines in Excel
  82. error handling in procedure
  83. Combining Excel Files
  84. Count Sheets
  85. Export Excel to .txt
  86. Loop...every sheet until [End] sheet
  87. Code error when cancelling
  88. Run Code only when OK is pressed on Form
  89. Multi selection list box
  90. Toggle Text Color in Cell A, when Cell B clicked...
  91. Two Dimensional Lookup and Cell replace
  92. Properties not staying with UserForm
  93. ActiveSheet Range not working.
  94. Delete Worksheet
  95. Names along with Macros
  96. Get 1st and last addresses of cells in a range
  97. convert excel workbook to web
  98. passing control from control to the worksheet
  99. Returning Workbook Name Containing Macro
  100. Split Cell by Delimiter, Move to New Row...
  101. Date generation in column.
  102. For....Each Problem
  103. Autofitting Columns
  104. Updating multiple cell values
  105. Hyperlink trouble
  106. Macro to import a flat file using 'text to columns'
  107. need repeating procedure to change row height
  108. Can't lock cells
  109. Reverse VBA action!
  110. Access Excel VBA Control
  111. [SOLVED] autosort data when data changes and then link to sheet
  112. Please help me out guys
  113. Function Keys with Userforms
  114. Filtering a Filtered Range
  115. Error Message everytime, First time I open Excel doc
  116. How to convert dates from the 1800's
  117. Sending email with outlook signature
  118. Update some Type of Tables to Run Program
  119. copy paste w/deleteing unsed items
  120. Delete partial text
  121. GetOpenFilename to display only files with NO extesions
  122. Insert a Filtered Range
  123. FIND not working in macro
  124. macro to delete images.
  125. Save worksheet to document file name
  126. How does this code output the coefficients of a trendline?
  127. Find and copy rows to new worksheet
  128. formula structure in a macro
  129. Jump-To macro
  130. After macro, crash if save
  131. Snapshot to excel
  132. Full name help
  133. cell filler application
  134. Total entries between two values
  135. Loop Macro
  136. Move to Other Sheet
  137. Selecting Columns Using Variables
  138. Average from string data
  139. Capture result for Unprotect method
  140. Custom Toolbars macro always refers to new saved filename
  141. date format being changed from UK to US
  142. changing pivot tables - vba code for an event
  143. split one column into two, according to the lenght of member
  144. Automated email on active cells
  145. Sizing a picture based on a value.
  146. Cut and paste value to corresponding date
  147. Using select case yesno to print data
  148. How to click the down arrow to see validation list
  149. Early binding reference list, add all?
  150. Close Input Box and do not filter when cancel selected
  151. Insert Rows in a Dynamic Area and then Add Text to New Rows
  152. Lock Button that Locks Specific Cells
  153. How Can The Macro Rename Files When The Original File Name Changes Everday
  154. how to check cells depending on bottom cells
  155. Error With a Do Until Loop
  156. Header Value matches, trasnfer the data to other sheet.
  157. Generate Nested folders
  158. If Statement Trouble!
  159. Using VBA to generate random numbers
  160. set formula permanently
  161. How Do You Save As A CSV File That Uses ";" To Separate Values?
  162. Looping through buttons in Userform
  163. Query to Get specific data
  164. Autofill Relative Equation Across Sheets
  165. is there compatibility issue between 2003 & 2007
  166. copy data from multiple files to a single
  167. automatic path for different server maps
  168. control worksheet with combobox value
  169. Create Nested Directories
  170. Creating A countdown timer
  171. count a word repeated in a cell
  172. Referencing a late bound Excel sheet
  173. VBA to choose between equally likely possibilities
  174. option pricing with range
  175. Clear all filters from table
  176. Text to dollar value to sum in different column
  177. Vlookup in VBA not working properly with Forms
  178. VB code for ENT or ESC
  179. create a program with result by clicking
  180. Disable New Windows
  181. VB code error when workbook loses focus
  182. Closing the workbook without saving
  183. Summing entries of the same cell (Accumulator)
  184. Popping up "Please wait" msg
  185. copy row to new sheet
  186. Real time update of Userform label with cell value
  187. Import Other Excel Spreadsheet into Current One
  188. compare two column(group by group, maybe?)
  189. Complex formatting issue
  190. Vlookup, Hlookup, otherlookup?
  191. Comparing Content of 2 Cells in VBA
  192. Worksheet Macro to add page numbers
  193. Excel 2003 Error
  194. Email attachment problem
  195. Copying an offset range
  196. macro to obtain tab name and use it in formulas
  197. Call Worksheet_Change from diff module
  198. Macro or ASAP Utilities
  199. copy data to new worksheet
  200. quick sort code
  201. Copy and Paste based on conditions
  202. how to insert code?
  203. Help Creating a master "database" from mulitple Workbooks
  204. Palindromic problems!
  205. Help!!!!!!!
  206. update every cell to reformat?
  207. Shaired workbook
  208. Get multiple answers depending on other text
  209. Automatically format multiple worksheets
  210. Problems copying data across worksheets in VB
  211. Excel Macro>Input box Macro
  212. copy specific worksheets based on textbox input
  213. Automated cell copying
  214. Open IE shortcut from code or IE as "Run as"
  215. Conditional formating with VBA
  216. store on the Filename from the full path
  217. key 1/8/2008 will show 1/8/2008
  218. Hide worksheets
  219. checkbox change event in form
  220. Calculation code
  221. Textbox to data column
  222. Create Worksheets Based on Cell Values
  223. Help to download internet files(spreadsheet)
  224. Count Unique Items in PivotTable?
  225. Reset pivot table fields in multiple sheets
  226. Countif with VBA
  227. Sorting Columns using Code
  228. Find and Highlight a group of numbers
  229. Macro to resave contents of entire folder as CSV
  230. Summing data from days to Months realtime
  231. Consolidating Worksheets
  232. Copy & paste ranges separated by blanks
  233. Consolidating an offsetting code
  234. Automated copy paste using macro
  235. User forms, filtering
  236. Summing based on Criteria
  237. Macro searching for the closest value
  238. functions with Dim as Double
  239. Page Numbering without footer or header
  240. RangE NAME HELP
  241. search through a list with 2 conditions
  242. If-all conditional
  243. Application.screenupdating fail
  244. Macro to automatically autofilter and print sheet
  245. Add Circle around a cell
  246. conditional formatting displays incorrect value when time is 12:00
  247. Clear contents based on criteria
  248. Moving recent data
  249. Msgbox: How to do it?
  250. run macro after choosing in a dropdown list