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. Error msg when open workboobk
  2. Search for partial value
  3. send information from Excel to an outside program
  4. RefEdit remove anchor
  5. MSNStockQuotes
  6. auto highlight a cell
  7. Copy new sheet then add sheet name to list?
  8. Passing a worksheet name as a reference
  9. Add Remove rows useing scroll bar
  10. Activate inserted column for concatenation
  11. Macro to copy from Excel and paste into a form on IE or Firefox?
  12. cell sort/transfer
  13. too many criteria for sumproduct?
  14. select case with a list?
  15. Reduce workbook size
  16. UserForm Control
  17. Time and date stamp
  18. merging 4 columns into 1 new column
  19. Stop Menu Items deleting on Cancelled Close
  20. Repetitive VBA code
  21. Hide duplicate rows
  22. Addin Installation & CommandBar Creation
  23. Delete Text Only
  24. Generate unique no automatically
  25. Amend This Loop Macro
  26. Export chart format to VBA
  27. building a sort string
  28. User Form Question in VBA
  29. Hide Sheet Query
  30. multiple formulas
  31. adding new worksheets to the bottom of an existing one
  32. Button visibility and colour
  33. Macro / VBA question
  34. problem with OLE server?
  35. Automatically Select a Cell
  36. 424 run time error object required
  37. Macro to copy a sheet
  38. VBA and a small database!
  39. Showing similar data in a new worksheet
  40. find, meet condition, sum range, deduce, find next
  41. refresh from web with delay
  42. Excel Forms: Updating data real-time
  43. How to get last name from A Column to copy to B column
  44. Use Macro to add data to end of a list
  45. Using strings as arguments
  46. Delete Data with code
  47. Converting cell colors to hex code
  48. Script out of Range
  49. Check delete condition.
  50. Switching between workbooks
  51. Filter data using Combo Boxes
  52. Make "worksheet names" variable
  53. Still having problems extracting Min
  54. UDF for FIFO Valuation of Inventory
  55. Order Form
  56. Scroll Wheel will not work in VBA editor
  57. consolidate data from folder using vba
  58. Print visible sheets
  59. IF multiple cell's yes....
  60. Remove duplicates
  61. another extracting min from one column question
  62. Find string and offset copy
  63. Finding String and setting flag
  64. extract min from one column to another
  65. Cell that displays .xls etc, depending on file name
  66. Auto changing row color depending on dates
  67. Hiding even number rows
  68. How to create List in excel2000
  69. Multiple Find and Replace to replace a list of strings
  70. convert text data to remove *
  71. Copying data from sheet to sheet using VB
  72. User Form Text Box Select All behavior
  73. Position property
  74. closing workbook of variable name
  75. Prev Cell Address & Sub Caller Name
  76. strCol
  77. exporting via VBA to Access
  78. Adjust Chart Size
  79. Sort names (first,last) into correct columns
  80. macro button for database like sheet. Update & ReSort list alphabtzd
  81. Copying a MSAccess file while open
  82. Using rows as header?
  83. Outlook Automation of Excel Input
  84. Data Validation/Drop Menu with Hyperlinks?
  85. multiple workbook extraction
  86. Text Box in a Chart
  87. Clearing a Form
  88. Tranforming matrices
  89. Using variables in a VBA range
  90. How to use the count function?
  91. If/Then formula Exist?
  92. Add a textbox using VBA
  93. How can 1-Msgbox be used in place of Many?
  94. Path for File Saving Defined by USER
  95. sort doesnt work with Range of cells
  96. Selecting cells via the inputbox
  97. Saving CSV file as a cell name
  98. VB basic syntax site online? Help file broken
  99. Deleting rows with no value.
  100. Userform auto-size
  101. VBA: "Un"-Dropdown a Combobox in a Userform
  102. Userform To Input Formula
  103. Selection.Replace Problem with Date
  104. Selecting Price based on date
  105. User Form: Button Return Order
  106. format Cells type "text"
  107. Dialogsheet
  108. Force Entry on UserForm
  109. SUM(iCol & "7:"...)
  110. Creating a copy of the workbook and changing some cells contents
  111. Cant Seem To Deselct RefEdit Box On Userform
  112. macro to locate and close workbook
  113. Macro for saving
  114. Replace 3rd & 6th Char in cell with "/"
  115. Creating a macro for all documents
  116. Dependant Combobox in userform
  117. Force cell date format
  118. Msg Box
  119. Fill A Userform Listbox With Names OF All Open Workbooks
  120. worksheet event
  121. Product price with marges
  122. Trying To Create Form To Output Data And Erase Form Once Data In Ouput
  123. fill in the blanks
  124. Reset cells to zero
  125. copy each columns in a generate txt for each column
  126. Code to download information from notepad and copying info to the excel
  127. determine a variable's value then use it in another procedure
  128. macro to copy result to another sheet in next row available
  129. Moving Between Worksheets with Formulas
  130. Find a line of text and insert 5 rows
  131. Sendkeys Question
  132. Run code when open file
  133. Finding Duplicates & Deleting the ROw
  134. unknown cell referances in a macro
  135. Autofilter: Page Fields: select if only one entry
  136. adding a "are you sure" pop to a cmd button
  137. Macro for drop down list
  138. Replacing dot by a comma
  139. Create/delete sheets from a list
  140. Flagging Bad Dates
  141. writing a loop to parse multiple sheets.
  142. Obtain Conditonal format color
  143. Calling different macro with UserForm_activate()
  144. Calendar Macro
  145. Calling row with variables
  146. Pausing a macro to wait for the results from the query
  147. Deleting Rows
  148. Macro to copy cells based on the value of another cell
  149. Dissable Close button on Userform or Assign Code
  150. Extracting dynamic data
  151. Looking up data daily
  152. what is the corresponding value of xlCenter and xlBottom
  153. opening web page`
  154. add worksheet
  155. Grouping function in Excel macro
  156. How to connect rows/cells in Excel?
  157. Next empty cell
  158. Returning to selected cell after sorting/filtering
  159. VBA Code needed to copy and paste the format
  160. not to open the file after exact date
  161. vba Argument Dropdowns
  162. How can I fail based on an exception?
  163. Formatting data...
  164. Changing Existing Values with a Macro/VB Code
  165. e-mailing a range of cells
  166. Locking and Unlocking Excel workbooks
  167. vbscript does not understand :=1 does anybody know how to make it understand :=1.
  168. Userform Listbox For User Entry?
  169. filter from combo box? (not autofilter)
  170. .SpecialCells(xlLastCell).Select does not work in vbscript
  171. Saving a spreadsheet after emailing it
  172. 15 different currencies- sorting
  173. Turning AutoFilter off
  174. how to create a border in vb to reflect on the excel sheet
  175. VBA: Using the Find Method on an inactive sheet
  176. sPath saving to desktop on different pc's
  177. Counting text cells with strikethrough font!
  178. Error when combobox is cleared
  179. Stand Alone program
  180. how to write to excel sheet using vb
  181. Exporting to excel
  182. Error message: "Compile error. User-defined type not defined"
  183. Macro or Formula to extract data
  184. Make UDF for Mathematical Sum function
  185. check for file, if available run macro?
  186. Copy information from one cell to another
  187. Opening a workbook and collecting data from it
  188. Calculate a new date/time based on the input
  189. Function to name sheet based on on sheet names.
  190. cleaning up a table
  191. Excel Inventory Macro
  192. Make excel paste at certain row
  193. Save as then start a blank sheet
  194. Formula + code
  195. Calendar control not found in 2007
  196. end a looped macro at a certain sheet
  197. VBA InputBox
  198. Clear Contents
  199. How do I remove single spaces between words in spreadsheet?
  200. concatenate with spaces and commas
  201. Opening a file with only a partial file name
  202. comparing 2 columns and highlighting text data
  203. Changing Named Ranges
  204. Accessing Outlook address list via excel
  205. Name a range in VBA
  206. Browse for File to open
  207. Cycle excel instances
  208. sort by colours/formating
  209. Kick Users Out of Sheet
  210. duplicate data
  211. Assigning macros to AutoShapes
  212. Perplexing Macro Issue
  213. Auto populate value already pre-defined
  214. Formula + rounding
  215. Creating multiple sheets from data in 1 sheet
  216. Applying macro within a custom macro button to all workbooks
  217. Copy Duplicate cells
  218. Cell entry + data validation
  219. Left Function
  220. Dynamic Formula
  221. Vlookup function
  222. Parameter query
  223. error handling
  224. Can't Get Macro to Run Without Error
  225. Total time it took for macro to finish the job
  226. userform duplicating add data
  227. Ye Olde Combo Box Hyperlink Question
  228. run vba on current workbook
  229. combobox linked to textbox
  230. excel 2003, choosing a directory
  231. Conflicting results going from Command button to Call routine
  232. Macro Prompt User - Save As
  233. Question on Array's
  234. custom events
  235. Assign 1 Macro to Run Multiple Checkbox Controls
  236. Placing Date in footer
  237. Problem in Returning Values from a Multi-column Listbox (ActiveX)
  238. Picture Background
  239. using array with wkb.sheet.paste
  240. PasteSecial values fails
  241. sorting and creating new worksheets
  242. allow macro in protected sheet?
  243. macro to release list filter
  244. "Selection is too large"
  245. Command button to print highlighted cells.....
  246. Right click sheet menu
  247. Macro for Inserting and Formatting Word Object
  248. Best way to create an automatic updater
  249. VB formulae that adds variable number of cells
  250. Sys Button Color & RGB ?