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. Find cell based on formula result and delete contents
  2. Group Lines?
  3. Extract unique rows and incremental copy
  4. Workbook Protection Encourage Enable Macros
  5. Might be so simple yet.....
  6. UserForm - ComboBox - Row Source
  7. Hi MSP70779 Need a little bit of help on this please.
  8. Drop Down, Filter or IF?
  9. Find and format
  10. Counter in code
  11. VBA Mail font control
  12. Save Cell Id
  13. Help with pivot table macro
  14. Collecting the location of a hyperlink
  15. If statements in loops
  16. Declaring Interger's
  17. Macro - send a file to a specific location
  18. Placing art Pic in a cell with a form
  19. Error with Find
  20. Date code
  21. stop an entire row from calculating
  22. Change Paste Starting Cell In Macro
  23. Date Format problem in User Form
  24. Embedding Object Referances
  25. Enable an macro by double-clicking a cell
  26. code to find out if text box is empty
  27. Trouble with Time columns in vba
  28. Easier way to do this
  29. Macro to format large data set
  30. Multiple Inputs into other worksheets
  31. VBA problems
  32. Hiding Macros
  33. VBA - Clear info supplied
  34. Retrieving properties of any files (author,comments etc.)
  35. Webpage view with excel
  36. Workbook_Open Event
  37. make User Form inactive
  38. data form to browse & edit, with multiline textbox
  39. Selects and pastes data from wrong column
  40. message box problem
  41. Removing command buttons from a spreadsheet
  42. fin next empty cell in coloumn a
  43. Interesting SUM question
  44. how do I undo the result of a macro
  45. userform record search
  46. This may or may not be simple
  47. vlookup -need 2nd occurrence
  48. Need Help with copy and paste macro...
  49. Hide Protect VBA code from others
  50. Possible?
  51. Convert date format from string to separator
  52. Excel file icon
  53. Command Button with Macro on Different Sheet
  54. Release Variable from Memory Problem
  55. Scheduled Task to run a specific macro?
  56. Visual Basic Cell Reference
  57. Workbook_Open Event
  58. Filter values to populate a combo box
  59. Compile error: Invalid qualifier with inputbox
  60. VBA for Password Protect Formulas only
  61. Excel updates with VBA
  62. checking if a sheet exists in a workbook
  63. Looking for help on this code, please.
  64. Two Toolbox Controls Questions
  65. need alittle help here.
  66. phone number format question
  67. Spreadsheet model & buttons
  68. Printing page with specific columns in excel
  69. plot to label
  70. Loop
  71. Delete record in access database with excel VBA
  72. code to customize submenus
  73. VBA Code for a Required Cell
  74. Macros column heading help
  75. Search a directory for a file
  76. total macro
  77. Disable auto save?
  78. Copy and paste
  79. append data
  80. macro help
  81. Insert contents and email
  82. How to get rid of this prompt
  83. how to get the column width value
  84. Select only non-blank columns
  85. "Button" appears when mouseover...
  86. Buttons are now shown up on Excel Sheet!
  87. Pmt Function
  88. Built-in VBA search capabilities?
  89. Delete Entire Rows
  90. open a web page atomaticaly using excel
  91. Changing color of a cell using a drop down
  92. Ask the date range
  93. Delete the current workbook
  94. For Each Next Loop Problem
  95. page load problems
  96. Select to last cell macro help!
  97. Save "Protected Shared" Example
  98. Problems understanding automated emailing code.
  99. Cell properties - Need to simplify this code
  100. Categorize columns as per dates
  101. Charts from Excel to PPT
  102. Compile Error: Sub or Function Not Defined
  103. Column Headings
  104. Compare one spreadsheet with multiple sheets and update
  105. Macro to capture Sytem Events
  106. "RunTime error 429 ActiveX Object Cannot Create Object"
  107. Get current cell address
  108. Creating a hyperlink from within a form.
  109. how to check sheet1 exists
  110. Text Finding is complicated! Plz Help!
  111. search,rename and sort sheets
  112. find and replace macro in excel 97
  113. drop down menu and conditional formatting
  114. Beginner Quest: Macro's dont' work after changing the file name
  115. How Do I Sum Dates and Move the sum
  116. A somewhat different type of "concatenation"
  117. ActiveCell - What am I doing wrong????
  118. cell value depending on another cell
  119. Easiest way to convert to WS to PDF?
  120. Web query
  121. How do you collect and move pictures around using macros?
  122. Need help for Pick List in Excel
  123. Macro to rename worksheets
  124. help needed with macro
  125. COUNTIF different in Excel 2003
  126. Opening a spreadsheet with a specific name
  127. how to migrate to new laptop
  128. How to change Pivot table with Combobox selection
  129. refresh a pivot table
  130. Translation Tool
  131. Meassage timer help appreciated
  132. Call passing variables
  133. Obtaining a pivot chart Legend name
  134. Get info from Web Query
  135. Password at VbProject
  136. Sum filtered rows
  137. Minimizing Excel Menu
  138. Add seconds to Timer?
  139. Range.FindNext Issue
  140. Select/process Variable Range with Macro
  141. Windows Explore tree
  142. Input Box for Columns
  143. deleting rows based on cell value
  144. Save/Return Location
  145. Simple VBA syntax question
  146. User Defined Function help prompt
  147. Trying to pull Data from 52 xls files.
  148. Database query variable
  149. Creating Specific View Macros
  150. Backwards chart
  151. Problem with a code
  152. Find & Replace "Singular Case"
  153. Form Object assignment
  154. Fill values down to the bottom cell of a column range
  155. Object References
  156. Timer Help
  157. Using VBA to Protect
  158. Need help with a macro that will change digits in a number.
  159. Excel and other programs
  160. Check cell contents
  161. Waht's wrong with this code? Thanks
  162. Random Cell
  163. Dynamic Ranges
  164. Textbox Max lines
  165. Ctrl + F ( Search Box )
  166. Force Manual Calculation for specific area
  167. scroll bar issues
  168. CSV Macro
  169. Selecting sheets with a macro
  170. Need Help With Excel Macro To Find & Replace
  171. Select/With/For Next - Which is right?
  172. Live Charting
  173. Links for Beginners
  174. Combobox Revising with every access
  175. Custom message with mouseover
  176. Import Macro trying to gain acces to file that doesn't exist.
  177. Passing data to Macro
  178. Copy Web Link And Extraction
  179. Set autofilter print area with code?
  180. Columnwidths for listbox columns
  181. Activate Macro
  182. If Activecell + 2 criterias
  183. Detection of charts, pictures and external links
  184. Function to seach a max value from ddmmyyhh
  185. Is this a bug in VBA?
  186. Need help please.
  187. Deleting Specific Shapes
  188. Need Help Building a Search Function
  189. Two variables to define cell address
  190. Render Length of String? Wrapping problem
  191. Textbox on a form linked to a cell
  192. Usb
  193. duplicate auto quick info
  194. Query Access Database
  195. Creating Formula
  196. Searching Column A and puting a check mark in Column B
  197. Calendar control not found
  198. multiply with VLOOKUP
  199. disable update screen?
  200. Spinner and Dates
  201. Hide application
  202. Object Variable or with Block Variable not set Error
  203. Need help on macro programming
  204. Date compare
  205. Find Worksheet
  206. showing a page from a multipage
  207. Help me understand this SQL string!
  208. macro to search in data, then copy it.
  209. Excel Function for Active Sheet
  210. Time troubles
  211. Insert New Column
  212. current version
  213. Multi-selection listboxes and storage of selections
  214. Conditional IF's
  215. Counting the Number of Months
  216. comparing
  217. VBA to delete all Macros
  218. Personnel Costs - HELP
  219. Using GetChartElement Method launches Goal Seek dialog!
  220. Closing application
  221. Password To Modify or Move A Picture
  222. Sending text message
  223. Excel macros to PowerPoint problem
  224. Complex averaging problem
  225. storing and manipulating data help
  226. Delete blank rows on manual selection
  227. "Emergency" stop
  228. What's wrong with my loop ?
  229. Excel VBA programming
  230. Change Excel 'overwrite file?' macro
  231. Listbox issues??
  232. VBA Help
  233. Minimum Stock
  234. getting information from a pie chart
  235. Adding to my listbox???
  236. Linking macros together....
  237. How to remove character's in a row
  238. Selecting Cells in VBA
  239. conditional if statements
  240. Help with VBA scripting
  241. Issue with updating links etc
  242. multi sheet forms
  243. Protecting Pivot Tables
  244. copy rows to a new worksheet based on cell value
  245. Not sure how to detect this...
  246. issues with coding problem
  247. Userform Combobox problem
  248. File Browser
  249. Column Specific Code
  250. Private Sub Worksheet_Change