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. macro keeps running when I start Excel
  2. Resolved >>> How to get Macro to run if condition met?
  3. Resolved >>> Macro has stopped working in Excel XP
  4. Copy a cell in a multiple others until...
  5. open and save as
  6. VBA close workbook without yes/no prompt
  7. Allowing autofilters on protected workbooks
  8. Application-defined or object-defined error with unshare/share macro
  9. times seperator as a "." instead of ":" plus validation
  10. Excel macro security not working?
  11. Numeric Sequence Validation
  12. Vlookup/Hlookup problem...
  13. How to call userform/sub in Addin from worksheet event
  14. Save Userform as an add in
  15. Sequence of control names in an array
  16. TextToColumns > MDY
  17. How to get a range from another Excel file without opening it?
  18. Return remainder value
  19. How do I minimize the Ribbon using VBA
  20. Flashing or blinking cells as a result of a "If then" formula
  21. lookup function with pivot table
  22. Resolved >>> Place the actual date in a cell
  23. Resolved >>> Common Dialog in Excel 2007
  24. Scatter plots with non-contiguous data after auto-filter
  25. Resolved >>> where to put this code for userform
  26. Resolved >>> Creating new sht from template sht & filling in summary sht - userform
  27. Resolved >>> Sound User Function Not working
  28. sub total macro query
  29. Update Linked Excel Worksheet
  30. highlight row(s) based on values in particular cell?
  31. Copying specific rows to new worksheet
  32. command button on worksheet menu bar
  33. Autofocus on next text box
  34. Loading Custom Data Type ?
  35. How To Insert 50 Rows & columns
  36. Data parsing/arrangement
  37. validation in a textbox
  38. Reference text in additional worksheet by category selection
  39. Linking Sheets
  40. Resolved >>> How To: List Recent Changes to Document?
  41. Resolved >>> Re-Arrange an Excel Table
  42. Forcing a line feed within a cell (Carriage Return)
  43. Error in code
  44. VBA Accessing an unopen spreadsheet
  45. Making automatic headers in a macro
  46. Detect Security Setting
  47. Macro to cut a row from one Worksheet and paste in another
  48. Conditional Text Insert
  49. input number to define range
  50. devide all...
  51. Grading Questions with Multiple Parts
  52. SharePoint and Excel Macro Interactivity
  53. Counting values in textbox 1 - 25 in a userform
  54. Evaluate, Offset, & strings, can I ?
  55. Resolved >>> Macro Error
  56. User defined function returning #VALUE!
  57. Ontime to capture cells values at a giving time
  58. Resolved >>> Format Master sheet the same as other worksheets
  59. CommandBar
  60. Thanks to All!
  61. Filter on today's date forward
  62. Event macro to run when cell value is changed
  63. Run a Sub within a Sub ?
  64. Prevent Yellow color from printing. Make visible gridlines in a shaded block
  65. Point line of the comment
  66. Sum of range as variable
  67. Renaming sheets
  68. Update Chart during iteration
  69. Using smallscroll to find a value and move to it
  70. Why is command offsetting value?
  71. How to add existing sheet to an opened workbook?
  72. Search for rows in one sheet and copy into another sheet based on customer id
  73. Simple user form?
  74. sorting records to display list box options
  75. Creating and Editing Word Doc from within Excel; Procedure Randomly Stops
  76. Tabbing from Cell to ComboBox
  77. Change cell format based on another cell
  78. How to keep it from looking like its locked up
  79. Opening a Workbook
  80. Rounding to the next whole number
  81. Arguments for Double Click event
  82. Script for auto cell formatting
  83. copying range with connection in it ?
  84. Hiding system menu under Excel 2003
  85. Runtime error '6' : Overflow
  86. Check for a password before open
  87. How to use a Treeview control in a UserForm
  88. How do you use a macro to format subtotal rows?
  89. Event Macro - Clear a group of cells
  90. before double click event of worksheet created by program
  91. change visiblity of a spin button
  92. Printing Dates to a file
  93. excel alerts
  94. VBA Macro & ScreenLock
  95. check out of date
  96. Conditionally hide a row
  97. Copying formalua and Pasting as values
  98. Automated Grouping / Total Query
  99. Dynamic Range
  100. Populating Word Bookmarks from Excel macro
  101. Disable close button
  102. timer
  103. Saving a sheet
  104. Before Save- where and how do I use this?
  105. Resolved >>> Placing a chart on a userform
  106. Writing cells on a protected worksheet in a shared workbook
  107. Timer in milliseconds
  108. Userform problem adding to existing rows of data
  109. Pull Range From Closed Workbook Into Another VBA error
  110. How to use macro to do loop and calculate averages of rows
  111. macro to copy from one sheet to another
  112. For each loop issue
  113. How to test for working web links
  114. error handling
  115. How to position a TextBox using the chart scale
  116. Resolved >>> How to allow contents to be replaced
  117. Macro for inserting a check mark in several columns on right click
  118. Protect worksheet code - allow unlocked cell select
  119. Import from Excel, add to collection within Access
  120. Macro Linking Checkboxes to Cells with Relative References instead of Absolute
  121. Auto Sum & Macro Issue
  122. Minimize button
  123. How do I sort and export data from one spreadsheet to three others
  124. Create list that has duplicate entries
  125. Userform Icon
  126. Adding formulas to summary page using loops
  127. Copy but avoiding selecting
  128. macro to toggle cell value
  129. Word wrap in text box
  130. Clearing input values
  131. Moving files
  132. Embedding Objects
  133. Use Combo Box To Define Which Column To Autofilter
  134. How to Use a Variable in a Formula
  135. Running a macro on current row
  136. "customize" the scan to always scan a letter size page
  137. Copy and Paste
  138. How to simulate Datatable behaviour
  139. Type Password, Show letters as asterix's
  140. VB Reference Microsoft Internet Controls not found
  141. How can I ensure entries in a column are 16 chars long using spaces?
  142. Search string in excel macros
  143. comments won't stay still!
  144. Transfering Row of Data to Another Sheet while Skipping Blank Cells
  145. Sorting Excel sheet by VBA
  146. Automating a macro
  147. How do I import large .csv file row by row with progress bar?
  148. weird if then or vlookup question
  149. Sheets.Protect UserInterfaceOnly parm not working for me
  150. tool to keep running totals of lists
  151. Alphabetizing combo boxes
  152. Deleting Specific Rows
  153. Using VBA to sum data from a range of columns across several worksheets
  154. deleting subtotals with value of 0
  155. How to check if a cell has a value
  156. Add "1" Macro
  157. R1C1 Formulas
  158. After adding userforms I can't test the program
  159. Modules- what to do with blank ones
  160. Validation List To Drive Autofilter?
  161. Excel destroys clipboard content
  162. Insert a row after the first last cell of a set of data (or before the the first set
  163. Bubble Chart Macro (AttachLabelsToPoints)
  164. downloading files with macros
  165. code for prompt date to query sql
  166. macro to repeat on majority but not all other sheets in workbook
  167. Help Do Until Loop Problem
  168. Problem with Selection.QueryTable.Refresh BackgroundQuery:=False
  169. Pivot Table from MS Query
  170. Macro Page Breaks
  171. Checkbox Macro
  172. Apply two conditions in one cell within a macro
  173. Userform Macro
  174. Applying extra criteria when using macro to password protect sheets
  175. AdvancedFilter problem
  176. Hide Sheets on Opening XLS Unhide to Print
  177. How to protect part of a worksheet
  178. write a global macro
  179. Create a workbook from data in another one.
  180. Error Handling Using For/Next and Worksheet Functions
  181. Custom Excel Macro
  182. create VBA Feedback Form
  183. count if different
  184. POST a value into a cell through query string
  185. Print order for range in macro
  186. Counting values in list and displaying top 3
  187. COUNTIF Numeric
  188. Drop list with macro and some data
  189. Automatically filling comment boxes
  190. Graph Macro
  191. Copy Part of String
  192. New Combo Box to identify record then display all associated data.
  193. Findfirst function
  194. OpenText Method FieldInfo Arrays
  195. parse out a cell containing last name and Find Method
  196. How to get the info of the Excel file Comment.
  197. protecting VBA?
  198. Multiple excel files and collating specific cell info
  199. on-hand type workbook
  200. simplest VBA code to exit a sub using On Error?
  201. Date Diff Calculation
  202. Combo Box To Jump Between Sheets
  203. Combobox - Filter list in drop down
  204. ADO Macro with people online?
  205. VBA Code to extract and save sections of worksheet to seperate files
  206. Macro to replace part of hyperlink
  207. SaveAs doesn't save file
  208. Code to replace text in a range of cells in a particular column
  209. On error problem
  210. Resolved >>> Macro to go to specific sheet upon choosing option
  211. Stop a user from saving the file.
  212. Question about Private Sub
  213. Columns in combobox
  214. Auto-Open problem
  215. Maintain an update column for each cell update
  216. Time in milliseconds
  217. Problems defining a range.
  218. Rewriting the AND expression
  219. Prevent Checkbox2 being Selected if Checkbox1 is Selected
  220. Use Match to locate a item in an array
  221. script manipulate and edit an Excel spreadsheet
  222. Find And Delete Row Macro
  223. Worksheet Deactivate
  224. Offset issue
  225. Change text within a cell
  226. Format detection...revisited.
  227. Set Userform to Monitor Resolution
  228. Conditional Formatting
  229. If statement to check if .xls file is already open
  230. Clearing Subtotal ticks
  231. Prevent a character from been entered into a cell?
  232. Issues cleaning up External Query VBA
  233. Lotus Notes macro
  234. Referencing other sheets in a workbook.
  235. Getting the range of the selected cells
  236. Shared Workbook - Saving Issues
  237. Hyperactive Comments
  238. deleting blank rows with macro
  239. Running a procedure automitically if the value in a cell is "True"
  240. hiding rows based on two columns
  241. Named Range not recognised by VBA
  242. Add Ins Path
  243. Checkbox runs same macro when clicked or unclicked
  244. Error message when someone paste over Data Validation cells
  245. Excel and Web Query Question?
  246. Last in Range
  247. Forced Upper Case
  248. Macro to Copy Data from a Pivot Table
  249. Converting VB to Excel VBA
  250. For each next statement error?