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. Excel Password
  2. Worksheet Store
  3. Macro into locked cells
  4. Problem with querytables from search return page
  5. Add data & print
  6. Autofill Formula
  7. Start Macro on cell update
  8. How to make excel display worksheet 1 of ?
  9. Msgbox background color
  10. Stumper - printing a file based on cell value
  11. Copy Specific Range
  12. pivot table doesn't update on sheet active
  13. macro to look for data gaps then select??
  14. Copy Selected Rows To Another Sheet
  15. floating userform
  16. Error opening Excel with macros
  17. Excel Macro
  18. Searching Criteria
  19. Basic Loop command
  20. Data Validation in Userforms
  21. Populating Excel Templates through C#
  22. Code needed that will run a check procedure every 5 minutes.
  23. formula help please
  24. Rename worksheet name "Sheet1" in VBA
  25. GetObject / Inputs from Text file
  26. Loop?
  27. Import Macro
  28. Macro and missing option?
  29. Combobox in a userform
  30. Automatic Password Entry
  31. Macro?
  32. Delete and Match
  33. Change Buttons in Message Box?
  34. Help with drop lists in a userform!
  35. popup box
  36. delete
  37. Macro Weekly to daily data.
  38. Date Format()
  39. Lookup Challenge
  40. Replace Function Across Range
  41. Macro Running Twice every 10 mins rather than once \-:
  42. Macro error
  43. Changing default folder for SaveAs dialogue
  44. Excel Macros??
  45. Vlookup Problem
  46. Find heading, the subheading, display value
  47. Simple Compare
  48. searching for empty cells in a range
  49. Checking Date Input
  50. refresh pivot table when data changes
  51. Set font in VBA
  52. Delete rows based on date range entered?
  53. Count Cell Macro
  54. Prevent a user from running a macro
  55. VBA macro errors
  56. Conditional Formulas
  57. ? macro slows when other wkshts open
  58. Automatically add and execute vba macro
  59. Time Delay Macro
  60. Link two User Forms
  61. argument descriptions for user def function
  62. Shell Execute and running applications from VBA
  63. Out on userform
  64. Select Method of range class failed
  65. Good Excel Programing books?
  66. Warning on exit
  67. Delete Duplicates According to dates
  68. custom function looking at the color of the text
  69. Very complicated macro
  70. Routine Test
  71. Select entire columns from list.
  72. Currency in Word
  73. CommandButton VB Help
  74. Loop error
  75. Help with a Vlookup / paste VBA Macro
  76. Find function for forms
  77. Filter data to other sheets
  78. Spell Check in a form
  79. Installation Problems
  80. Help with a formula
  81. Loopy
  82. macro
  83. Find using VBA
  84. find number that doesnt exist among others.
  85. Getting Data From Regular Server
  86. "Loading ... Please Wait" Message
  87. cell locked
  88. how to automatically convert desktop shortcuts to hyperlinks
  89. [SOLVED] sort my range
  90. Macro to include a file as object
  91. sending cell contents to serial port
  92. Worksheet Activation Weirdness
  93. Macro for Cost Sheet
  94. Converting text to date
  95. Converting all displaying values to other currencies
  96. Disabling CTRL + BREAK
  97. OnClick Sub Deletion from VBE
  98. Called a sub twice, failed in 2nd call, why?
  99. Importing text file to Excel
  100. ADO command.createparameter
  101. excel or acess
  102. searching within a textbox
  103. Question scoping a column and finding certain numbers
  104. Simple Array
  105. User Form
  106. Freeze Panes in VB Forms?
  107. Using OnKey in a UserForm - possible?
  108. VB code - To Speed up process
  109. Programs in Excel, but no excel layout...
  110. Code Speed Question
  111. Macro
  112. ActiveCell.Row problem
  113. Listbox issues??
  114. Dynamic formula reference?
  115. Is there a way to Temp Pause and Resume a Macro?
  116. Send selected values from Listbox to Sheet
  117. Images
  118. Drop down Menu - change of colour
  119. any idea to retrieve excel range values from background process?
  120. Error message opening file
  121. I cant get this to work backwards
  122. Cancel Button...
  123. Programming a formula
  124. A lot of buttons
  125. Save Issue
  126. validation help
  127. How to connect to worksheet .
  128. excel and vstudio problem
  129. Open and close custom toolbar on startup/exit
  130. Excel Equation Solving...? Critical
  131. Passing Parameter between Excel and asp
  132. XMLhttp VBA & SSL
  133. Changing the code name of an automatically created combo box
  134. Another date as European problem
  135. vba environment memory?
  136. Help My Macro Doesn't Work!
  137. populating a listbox on a user form?
  138. userform listbox
  139. Save properties when exiting a Userform?
  140. Number Validation problem
  141. How can I do that loop with 4 colors....
  142. Pausing your code
  143. Clearing the clipboard
  144. Delete a Row
  145. Excel sheet Saved as word doc using cell value
  146. VBA Copy paste columns on if statement
  147. multi-column dulpicate search
  148. a test for #N/A
  149. Missing VBA Module!
  150. converting a variable to uppercase.
  151. VBA/Macro - Can this be done
  152. Adding a textbox via command button
  153. Command button to run only a portion of the code
  154. Dynamically/Automatically written code
  155. Selecting & programming Lists in Table
  156. Weird Error!! Can someone help please
  157. Amending Download Information
  158. Chance of a number being selected
  159. excel form loading from powerpoint
  160. Mission Impossible?
  161. "Dir" command problem
  162. Selected Method of Range Class Failed
  163. table interpolation
  164. Data Retrieve for Condition
  165. problem with clear up cells
  166. Change font size using VBA
  167. would this code find a worksheet that his hidden ?
  168. finding if more then 1 copy of a sheet exists?
  169. whats the maximum nr of Worksheet_Change events?
  170. Condtional format range
  171. UserForm
  172. Macro bug with Sharing and Unsharing
  173. Macro to create a new file, saveas and close file
  174. Error checking text box entries
  175. vlookup on multiple closed workbooks
  176. help for Random no
  177. Cell content validation
  178. how to insert formula in VBA
  179. Finding certain #'s within a range of cells.
  180. fractions? can anyone help?
  181. FormulaArray and Loop names and '' ''
  182. can't copy a function down a column
  183. Conflicting VBA codes
  184. problems with listbox
  185. select range that is a right angle triangle
  186. Activating Sheets in another file and writing to them
  187. Macro to save file based on cell value
  188. Worksheet_Selection Change Event
  189. referencing using the solver - need HELP
  190. Xl 03 Vba: Matching, & Deleting Both Records
  191. on time procedure
  192. Small Problem
  193. Vlookup
  194. Search text inside a string
  195. Creating a macro
  196. Inserting text into part of another cell's text
  197. how to replace cell references with actual numbers
  198. If file is open
  199. Copy rows formatted and with same hidden colums
  200. Set active field in Form
  201. strange result from SpecialCells
  202. Populating a scroll bar????
  203. VBA problem: Resistor Value ranges
  204. validation in useforms help
  205. need help with this prob
  206. Macro for Recognising Difference in Dates
  207. Date as European
  208. Find duplicates
  209. Find, sum and return value from 2nd spreadsheet
  210. Add name to range
  211. Recording Number of Clicks
  212. An auto updation issue
  213. code to prevent duplicate entries
  214. Numeric Values in a textbox
  215. Help with a formula
  216. Fill Blanks
  217. simple % change macro
  218. Return value from a function
  219. Row Height
  220. Print specific sections
  221. Sum Range
  222. Connecting to a server
  223. Passing an argument that represents an object
  224. Code cleanup help appreciated
  225. simple search macro
  226. VB Excel --> Max & Mini with Dynamics !
  227. XLA question
  228. Trimming Alphanumeric String
  229. Syntax of the SUMPRODUCT Formula
  230. Creating custom lists in VBA
  231. Variable Find reference to a column?
  232. find and move
  233. Data arrangement
  234. Insert row with max length found in Column
  235. Merge Worksheets on SaveAS
  236. Stuck on a tough one (for me!)
  237. Excel Objects
  238. Searching an array
  239. simple macro to combine contents of two columns please
  240. Code help appreciated
  241. private sub macros and buttons
  242. Combo Boxes
  243. Query Access based on date
  244. Adding a control to a user form at run time
  245. Hey! Where'd My Menu Go??
  246. Delete Row
  247. DateDiff
  248. where can I find the list of shortcut references
  249. Form Resize
  250. Macro writing help