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. Save File with Current Date Info
  2. UserForm: visualise ControlSource
  3. Populating a Listbox, Worksheet Names as Variables
  4. VBA/VBE ADODB problem? 13: Type mismatch
  5. setting cell properties with a range of worksheets
  6. Basic Compare
  7. Hyperlink Panic ATTACK
  8. New to Excel Programming
  9. auto filter with combobox
  10. Insert Formula
  11. Copying text from a web site
  12. rookie
  13. Number format on VBA
  14. Putting spaces every few digits
  15. Why is there a break in code?
  16. A little help with some code
  17. Multiple Macros
  18. Results differ when running code with and without a BreakPoint
  19. put cell content into formula
  20. adding adressbook function onto a userform?
  21. Modified Date
  22. VBA: Changing Properties using Macro for Control Toolbox Items
  23. Question about an argument
  24. Performing calculations on arrays...
  25. Need Help with an "IF" scenario involving linking to a macro...
  26. how findout the calling cell address in a function
  27. Auto Inserting MS Office Username on Event Change
  28. ActiveCell Display
  29. UPS Web Query
  30. New to Macros-easy, pls help
  31. Will a Macro do it?
  32. converting yes/no to 1 or 0
  33. Multiple Timestamps
  34. UDF w/ 2 Condition: How?
  35. I'm in a pickle.
  36. finding a min value (real number) & colour cell
  37. result from multiple sheets
  38. Text Manipulation
  39. Need help comaparing two columns for duplicates
  40. VBA to count rows with criteria in one or more columns
  41. Help with some strange issues
  42. UDF: Convert 101206 to 10/12/06?
  43. current worksheet
  44. error in loop
  45. Can you print a specific number of pages?
  46. Automated hyperlinking using cell info
  47. showing drop down list when combo box is activated
  48. Controltiptext
  49. Automatic Web Query
  50. Delete Duplicate
  51. Need to disable Enter key in User Form
  52. Macro to Split Sheet in different
  53. Move on cell right form selected cell....
  54. Jab in VBA
  55. Excel Sort Macro is just giving me a "400" messagebox!
  56. Last cell in range
  57. counting from columns using criterias
  58. Search and copy macro
  59. TCP port data in Excel
  60. Help needed
  61. find replace col value
  62. Count Value
  63. Fill in Cell from name of Worksheet?
  64. help pages not working
  65. Compile error: Variable not defined
  66. Traditional Copy command
  67. Need help with a macro for comparing 3 worksheets
  68. "(blank)" in a pivot
  69. VBA Code problem
  70. Capture a range in input box prompt
  71. Removing absolute position
  72. Replace Value
  73. running tally in Excel
  74. skip startup form
  75. Save to multiple locations
  76. create input box for range of dates
  77. Formatting Cells
  78. Report Manager via VBA
  79. List sheets and count records
  80. Showdataform
  81. passing a range in a function
  82. Problem with code
  83. Timer
  84. Changing a Macro for new circumstances
  85. Disable Calculations
  86. match data and then dispay result in a form
  87. Macro search
  88. Delete cell and shift cell up
  89. Saving Macro so All Workbooks can Use It
  90. using vba to import text into excel
  91. Drift in Conditional Format Formula
  92. create new task folder in outlook
  93. Macro code
  94. Multiple cell address inputs to a macro
  95. reference for a cell in the same column
  96. Insert Copied Rows
  97. Go to today's date column
  98. VBA: how to hide a row (or column) with VBA
  99. Text-to-Columns VBA question
  100. need to skip calculation
  101. Need Userform to install in different file
  102. User Rights
  103. Comparing Filtered Lists
  104. formula to vba
  105. Background colour count recalc problem
  106. Extracting data from variable workbooks in a folder
  107. VBA Updating links using macros
  108. VBA/Excel formula issue
  109. Magic Table
  110. Excel Thinks my Variable is a Project ?
  111. VBA to sum total figures 600 or over
  112. Save Workbook
  113. Populate data from record set into list/combo box
  114. Went to excel07 got error with VB project
  115. It's stopped working
  116. Declaring a 2D array...
  117. Calender in a userform combo box
  118. Grouping and Sorting Help!!!!
  119. Macro to delete unwanted data
  120. VBA and Event Logs
  121. Help in highlighting
  122. hide columns on condition
  123. Write a password into a macro
  124. VBA Help
  125. WordArt - changing text color in code
  126. ADO: writing to .txt or .csv?
  127. Image linked to sheet but when sheet name change link is broken
  128. Help with functions in Darts statistics spreadsheet
  129. find first empty row then automatically input data
  130. Workbook with macros problem
  131. Macro to perform grouping levels
  132. Data cleaning
  133. How do I truncate a number using VB
  134. Need Help w/ Extreme Name Splitting
  135. Need to Conditional Format Custom Number
  136. Modifying a Input Box and Its Actions
  137. Combo Box Question
  138. Searching a excel database for the 10 best results
  139. Toggle Macro Security
  140. Problems with "shrink to fit"
  141. Web Query Macro with embedded proxy id and password.
  142. Need attention!
  143. averaging a column based on criteria andputting result in new worksheet
  144. Userform question - scroll bar on a multi page
  145. Search Marco
  146. Message box with lots of text
  147. Pop Up
  148. Outlook - email code
  149. comma delineated data
  150. Macro not working at year end
  151. sorting, extracting and listing data??
  152. check for new excel macro version
  153. display microsoft exchange server name
  154. Macro to compare data between worksheets
  155. How to Extract Data using Macro?
  156. Printing Active Sheet with command button
  157. Transfer xls to pps
  158. Should i use Code or WorkSheet Formulas ?
  159. Deleting Command buttons
  160. ADO reference
  161. Why does my code ONLY work with the last value not all in the range ?
  162. Sub as an arguement
  163. Another tough one
  164. Transfer Range to Sheet2
  165. multiple formatting within same cell
  166. referencing cell from different sheets in a loop
  167. Macro - Copy cell area and export to bitmap or any other graphic file?
  168. Highlight formula results that have a blank value
  169. comparing and copying multiple rows on 2 sheets
  170. Combo Box multi select into 1 cell
  171. Applying a simple macro over 100 documents
  172. Selected cells from worksheet
  173. Recording macro using cell references in worksheet
  174. Pivot Table VBA Question
  175. Change a cell color
  176. Design Mode
  177. Combo box problem
  178. Correct paste method
  179. Open closed spreadsheet by timer???
  180. Open file.txt For Input As #1, Is it possible without declaring drive name?
  181. Lookup
  182. Run-time error '1004'
  183. Extracing Data
  184. Value manipulation, String to Int, Int to Sting
  185. Strange textboxes addition problem
  186. Handle for read a line but nothing in it
  187. Split modification
  188. Shell command help
  189. Tricky sort (for me)
  190. Find and Replace Macros
  191. Match Function in VBA
  192. Delete rows based on multiple criteria
  193. Automating "Find"
  194. Creating a macro linked to a button
  195. Range is result of Find()
  196. Code wrong
  197. Text that dissappears when clicked on??
  198. Copy table from another excel file
  199. Complicated stuff! Struggling with VBA
  200. Using find command
  201. Textbox
  202. compare numbers and letters in same cell
  203. List Box
  204. Custom item under pop-up menu
  205. Open a list of txt files and put the calculation in excel
  206. Auto Number Column in reverse
  207. Going back on a user form
  208. copy a data range to outlook and send e-mail
  209. Formatting fields in User Forms
  210. bringing up the data -> form... box via macro
  211. Help with Select method of range class error
  212. Excel to filemaker
  213. Runtime Error Code 1004
  214. Is this possible?
  215. Displaying Excel onto Plasma Screen
  216. VB fill color code
  217. Inserting a formula into a cell using a macro
  218. I dont even know how to word this
  219. column merge
  220. OnTime Refresh function help please
  221. Macro recording
  222. HELP!!! suggestions on how to create a user-login / security level
  223. Replace worksheet when importing worksheet
  224. Post values into cells
  225. AutoFill border
  226. Worksheet function in VBA
  227. Volume Mute Button
  228. Move to compressed folder
  229. Worksheet functions in VBA
  230. VALUE# error from a form to a cell
  231. Link 2 textboxes from different sheets
  232. Macro stops responding...
  233. Hiding column based on all cells content
  234. copying data from excel into notepad
  235. Selecting A range in a different way
  236. link textboxes from other sheets
  237. Formatting
  238. DateDiff error in VB
  239. Deleteing Unneeded Rows
  240. Shortening Conditional Code
  241. Ctrldown
  242. Hiding columns w/ "|"
  243. Conditional formatting beyond 3 criteria limit
  244. shell command
  245. Lookup function?
  246. Totalling of selected months
  247. hyperlinks and copying data
  248. Auto fill down
  249. Run Macro with conditions
  250. copying a range of data