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. key controlled macros vs auto vba macros
  2. Combine 3 sheets of data
  3. Comparing values in a range
  4. Macro Autofill
  5. Date and time functions
  6. Required Fields
  7. Find Method not working any more
  8. How do I write this Function using Excel's IF
  9. Copy data from one worksheet based on column....
  10. Hiding Columns with VBA
  11. Setting a max/min value to use in a VBA function
  12. Macro button to copy and past last row of table
  13. Ending without 'End'
  14. Nested If Statement...
  15. Data Validation on Forms
  16. Sending a message to MSN Messenger contact from Excel
  17. Save As command but user filepath independant
  18. Quick one regarding sheet names.
  19. Macro to tell cell to become cell + 1
  20. Date modification
  21. Check box macro to copy that row
  22. simple macro help needed...
  23. Post data from multiple worksheets to summary sheet
  24. Checking to see if a user has access to a file...
  25. macro beginner error
  26. Count number of styles in a workbook
  27. Automated Exporting Sheets?
  28. is there a better way than a Do Until - Loop
  29. How To Make A Macro Recognize The Names Of The Columns
  30. Make a comment partially bold
  31. Add another condition to code
  32. How to copy data to last row of another worksheet
  33. Modify code
  34. For Macro - Specify Userform Workbook
  35. Strange bug/issue opening a workbook
  36. Message if duplicate found
  37. copy formula range down to last cell
  38. Date format debugging
  39. positive and negative numbers...
  40. RGB function with scrollbar VBA
  41. movable button
  42. did update cause code to stop working
  43. Macro for Pivot table not working properly
  44. Detecting closure of a workbook
  45. Hide Rows based on cell color
  46. #ref for Morefunc addin
  47. How to make white background
  48. MsgBox/ListBox/ComboBox
  49. check if E9 is similar with messages in 'B' sheet
  50. Count Numbers
  51. Search, Copy, and Paste Text
  52. Conditional format
  53. How to write a formula that changes font color?
  54. Date Macro
  55. Autonumbers and Userforms...?
  56. changing file name
  57. Changing chart source data in VBA
  58. Macro to get percentages...
  59. Summation a range of value
  60. Static Timestamp linked to checkbox
  61. VBE activate event
  62. Change Rotation of category axis in XL 2007.
  63. sum and sumproduct in VB
  64. Copy data into multiple cells
  65. check if legend is present in active chart in vba
  66. Submit button on user inputform "hangs" Excell 100% CPU
  67. Program to filter data in cells!
  68. Range Calculation VBA
  69. prompt in vba that will minimize but be available after the choice.
  70. Car make/model list
  71. Export Excel data to Word and PowerPoint
  72. Transfering data from one Excel file into another
  73. Mod code to split text
  74. Open Files
  75. Logging Cell Values
  76. only run autoexec macro once data has been retrieved
  77. progress bar
  78. Using macro to select next column
  79. Popup 40 days after timestamp using vba code
  80. Combobox ListFillRange
  81. Activate worksheet saved from input box
  82. Converting Cell reference to row and column index
  83. msg box question
  84. static timestamp that updates using vba code
  85. Disable Copy any sheet from workbook
  86. Stop from Viewing Workbook Code
  87. Initiate a VB sub each time Excel recalculates
  88. Run macro when file is saved
  89. save name dictated by cell value
  90. Calendar Pull Down ?
  91. Select a range of cells and then copy them, and paste into other cells
  92. Formula in macro
  93. identifying an area of filled cells in VBA
  94. wild & id key comparison and add - discrepancy finding
  95. Did Disable what method for cells ?
  96. Looping through a sheet?
  97. Text to Column, Changing date format
  98. VB slow in some cases
  99. How to disable copy or Move function of sheets,worksheets ?
  100. MAcro to lock and unlock cells depending on rows selected.
  101. Howto: Verify values between 2 spreadsheets, if same, copy value from adjacent cell.
  102. Automatic data entry
  103. Auto fill Macro/VBA(EXPERT HELP NEEDED!)
  104. vba to delete rows if criteria not met
  105. clear all formula but hidden
  106. Array Formulas Using the Sum Funcrion
  107. Formatting area using Data Validating drop downs
  108. Split Names using macro
  109. Excel cannot complete this task with available resources. Choose less data or close o
  110. Problem producing trailing zero in MsgBox
  111. Exporting a record to another sheet
  112. Macro's assigned to a custom toolbar button don't run after renaming the worksheet
  113. What is wrong with VBA code?
  114. Error Handling
  115. Named range of cells has disappeared!
  116. Auto save and close workbook after 30 minutes inactivity
  117. Unhide rows thru an event
  118. Double Time - During specific hours of the day
  119. Auto-fit cell height to show all data in it
  120. custom menu
  121. Excel 2007: OpenDatabase fails to connect to a SQL database
  122. Copy and paste to next empty cell
  123. Excel spreadsheet keeps crashing on save
  124. why doesnt it go to the cell I want to display
  125. Button that follows the scrolling
  126. Pivot table - copying & pasting the data into another sheet
  127. Macro needed to delete characters
  128. How to use Macro
  129. Changing cell contents, format etc. without selecting
  130. copying values next to found value
  131. Can I turn off the Excel warning about cell merging?
  132. Macros for load/save CSV files using pipe as field separator
  133. Copying Select Data From one EXCEL Sheet to Another
  134. Manipulating Shapes
  135. access to copyed (to clipboard) range
  136. save as and print options macro
  137. Altering the axis on a chart
  138. custom menu
  139. Edit with keystroke in range of cells
  140. If Else If End If
  141. Array Formulas Using the Sum Function
  142. calculate a single range macro
  143. Screen Resolution
  144. To give a message when a graphic is finished copying.
  145. delete modules of code
  146. Creating Outlook appointments from Excel
  147. search box function
  148. Automated removal of workbook_open macro
  149. Worksheet_Calculate() - Problem
  150. VBA macro for searching results in two sheets
  151. close hidden forms?
  152. Conditional format based on 3 sheets
  153. Is there a number of macros limit in 2003?
  154. convert formula to VBA
  155. populate sheet 2 using sheet 1 with a drop down
  156. Urgent help with VB...possibly VB
  157. Unable to get Array Formula Using Sum Function to work
  158. Registering keystrokes whilst a macro is running
  159. Copy A Range of Cells Or Sheet and Paste to A New Workbook
  160. Array Formula Using the Sum Function
  161. Macro to Print Update and Print Sheet
  162. automatically select next group of cells
  163. How to use macros
  164. Capture worksheet switching inside userform and update textboxes to new sheet
  165. Problem with JOIN in Excel Query
  166. Automatically Detecting and Erasing rows
  167. Running a Macro if Cell value equals "New Account"
  168. Protect All Sheets on Close
  169. Insert Data into new Row - How to find a new row?
  170. Excel to powerpoint and back macros
  171. missing control
  172. Range Copy loses precision with accounting type
  173. Find date
  174. Scroll Down
  175. Copy filtered list to new sheet?
  176. Setting pivot filter
  177. Delete row if column contains string
  178. Array to Range
  179. Excel chart shifts its position every time it is recreated using a macro
  180. Offset on a named cell ???
  181. Break Password
  182. Macro to replace IF statement that compares 2 cellls
  183. Change cell value and macro runs
  184. Validating with VBA
  185. Simple Copy and Paste Automation
  186. How to calculate average time
  187. Copying data to section of another worksheet
  188. Retaining leading zeros
  189. searching difficulty
  190. Duplicates! Count, Remove, Highight, etc...
  191. Have to add more rows bases in a column content
  192. search column "A" for every occurrence of the current part number cont.
  193. How to convert column number to letter
  194. Opening a file through a command button
  195. Check if files exist in a formula
  196. col and row value of active cell
  197. Lookup code
  198. Picture Macro
  199. VBA Error when trying to add macros
  200. If...Else query using wildcards
  201. Hiding Rows
  202. Resetting Spreadsheet Data Entry Cells
  203. error - variable not set
  204. combobox events and variable setting
  205. Run Macro upon cell changed by formula
  206. Only Numeric Value in Input Box?
  207. new workbook opens original
  208. Find Details of Files in Folder
  209. let a user open a new .xls file and get file name
  210. data order in a range of cells and vba
  211. Number retrieval in IP address
  212. Link / Button to Insert Object
  213. Format Message Box Text
  214. Having trouble with loops in a macro.
  215. Group/Ungroup columns based on Date
  216. Exit Sub when I hit cancel
  217. Export And Overwrite Existing file
  218. Change_event to add AM or PM
  219. Autofill help (xl03)
  220. Multiple IF Statements - Macro
  221. specify range for a vlookup
  222. Opening a workbook
  223. Non-declared variable
  224. Merging code - Validation and Formatting
  225. Delete sheets message
  226. How can i make a web query automatically with macro when no real webaddress showing?
  227. Matching Quantity between worksheets
  228. Time Calculation
  229. lookup references
  230. conditional formatting using IF with MID functions
  231. Conditionally format pivot tables
  232. Hyperlink format issue.
  233. How to Lock/protect VBAproject?
  234. make a mailing list that sends only one piece of mail to each couple listed
  235. Macro for dates and values
  236. Remembering and using previous values
  237. Macro on Sort
  238. Why does this code not work in excel 2007 ?
  239. Lookup?
  240. Problem with Range,Selection, Copy and Paste
  241. macro to give double usage to cell?
  242. Lock row of cells if... Macro
  243. Lock or just freeze Page
  244. How to know if someone else has an Excel file open
  245. passing multiple values to/from a function
  246. Popup window after running a macro
  247. Macro to Delete Blank Rows
  248. changing value of a cell in multiple spreadsheets
  249. carry results to next sheet
  250. looping a set of commands for a list