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. copying a range of data
  2. schedule data load
  3. Sending Excel through email using Lotus Notes
  4. search through dates
  5. Worksheet loop not working
  6. Insert a Textbox in a Frame during runtime
  7. Making 2 pages
  8. items in combo box
  9. Copy variable cells to different sheet
  10. PasteSpecial glitches
  11. How to use ComboBoxes in UserForm
  12. User Form that transfers data from one page to another
  13. Loop
  14. Need to Calculate Cell in Code formula
  15. Cycling through sheet names in VBA
  16. Custom toolbar sharing problem
  17. Force format into textboxes
  18. Insert a blank row in middle of a range
  19. How to reference option buttons on a spreadsheet
  20. Macro to call sheet number instead of name
  21. Locking non blank cells in range
  22. Combobox problem
  23. Need help to modify code to include more than 1 Column
  24. optimization with Visual Basic
  25. combobox selection adding new row to worksheet
  26. Transfer row
  27. Calling Macros
  28. Fill field with Last Date Modified
  29. RATE error in vba
  30. Payroll Help. Great Fun!
  31. Help with a simple macro - copy data into a column
  32. Remove numbers from Absolute Reference
  33. Data Sort
  34. cell info linked to worksheet name?
  35. data
  36. Need number of rows with over 599.99 in columns F, G, or H
  37. item textbox into cell
  38. extract data from notepad to xls
  39. List in Combobox
  40. Excel plus WEB World
  41. Access data in separate workbook
  42. Select Worksheet from name list
  43. transfer raw data to other sheets by matching hours and days
  44. Switch-case by Excel?
  45. Closing excel, no save message
  46. Call another subroutine when current routine ends
  47. Debug Error - Subscript Out of Range
  48. Formula/Macro for Outlook
  49. Fundraising Model
  50. Activex DLL
  51. Did I separate this correctly?
  52. scroll bar on list box
  53. Error messages in vba to check if userforms have been completed fully
  54. excel function in VBA?
  55. Macro to Super or Sub Script within cell
  56. Find duplicates within sheet and color
  57. Struggling with macro to rename file using current date
  58. Macro through alert
  59. compare strings in two workbooks
  60. Duplicate check and delete for thousands of records
  61. Changing a csv format to xls and saving/closing
  62. Macro to change month's number in a formula
  63. Deleting unwanted rows
  64. open file every 20-30
  65. Protecting a VBA project but allowing macro's
  66. Understanding Recordsets
  67. Payroll Help
  68. VBA excel load xml
  69. Updating Workbooks...
  70. Need help to total offset values
  71. clear msgbox while code runs.
  72. Combining data dynamically
  73. =INFO("directory") missing folders
  74. opening a sheet with variable file name?
  75. Making a macro-triggering custom menu button "travel" with a file
  76. Creating New Files
  77. Updating Current Master Price File
  78. Column Number for currentregion
  79. clearing a dropdown menu
  80. Conditional Expression
  81. Simple web query not working on company web page.
  82. hide/show textbox and line object
  83. protect a sheet?
  84. Treeview Control Drag and Drop
  85. Subscript out of range - Why?
  86. Get row indices where...
  87. How to program Escape key function?
  88. date problem?
  89. Autofilter sort protected sheet
  90. Autofill to lastrow
  91. UDF doesn't refresh result
  92. Help with Phone time in/out
  93. Adding textbox values
  94. Please help
  95. Close and exit program button
  96. Text box to search a list box choices
  97. Sorting data then exporting to new sheet
  98. Excel ODBC Connection to SQL Server table failed
  99. Reading an external file’s properties.
  100. VB Code to sum repeated values?
  101. fill Formula1 with named range
  102. UDF in User Form
  103. In theory can a macro do this?
  104. Test for cell format in VB
  105. Option button in User From
  106. VBA - Run-time error 54
  107. Macros not running frm protected project.
  108. Suggestions for this macro:)
  109. C program in excel
  110. Need Macro Formula Help
  111. Copy 1000 columns
  112. Need help with writing a macro that will only run if you key in a password
  113. very tricky !!! onkey macro re-opens closed spreadsheet
  114. add column x values until column y equals
  115. Named Cells moving with wrong worksheet
  116. Insert/format Picture From Folder
  117. vba on mac os 10
  118. Absolute Reference increment of 1
  119. Separate sheets duplex printed
  120. Code to select a range of cells based on cursor location
  121. Procedure too large
  122. pass 'focus' from form to sheet
  123. Need help to reduce file size
  124. Weird button-appearance problem
  125. Deploy AddIn containing references to libraries
  126. Activate Window
  127. frmCalendar
  128. adding to an existing line of VBA code
  129. Macro to set y-axis maximum to user-defined value
  130. Fill series
  131. Active Row Font
  132. show & hiding sheets
  133. 2 problems with sheet when going to 2007
  134. Invoice inventory
  135. Button linking to another cell and sheet
  136. Extract cell reference data
  137. Using Excel function in VB code
  138. Opening in different workbook...
  139. Message box using a form
  140. Tweaking a dropdown box
  141. Printing from a macro
  142. how to make it public?
  143. Hide Columns and Rows
  144. Macro to copy data from excel to notepad
  145. match date and retrieve data
  146. need help with writing a macro
  147. Simple copy macro
  148. Change Text message within UserForm
  149. changing vba userform colors
  150. Moving cursor to select input field in forms
  151. Hide a password
  152. Select shapes?
  153. identifying a certain word in cell
  154. Group Lines #2
  155. How Do I use Class Modules in Excel VBA
  156. Can i change font with If-Match-Offset across 2 sheets ?
  157. Loop/Repeat smallscroll
  158. Please help me with this macro
  159. list box- row source and bound column
  160. Request help with Case Statement and Merged Cells
  161. cascading combo boxes
  162. help
  163. VB comment
  164. Simple Operation Turned Puzzling
  165. Error when trying to delete row based on empty cells
  166. Pivot: Change PivotItems - Visible/Hide with VBA
  167. Help with copying and renaming sheets
  168. Carrying over Variable from UserForm to Module
  169. Help please w. simple user-defined function
  170. delete row
  171. Setting properties of controls in vba
  172. Function Question
  173. Keeping Record of Changes
  174. Importing raw data into Excel from TCP source
  175. A Macro to import objects from xml to excel sheet
  176. NooB question on macros
  177. VB problem for distiller 6 and excel 2003
  178. checking editable worksheet
  179. Checking Worksheet Protect Stage
  180. Programming Help
  181. Save not enabling in VBA Userform
  182. "parameter" worksheet
  183. Copy data from .CSV file
  184. Number Validation
  185. Dodgy array and loop - this might be very bad...
  186. selecting ranges
  187. Modify Last_Cell_Value Module
  188. Arrays
  189. I have a big problem
  190. copy excel data into an access database
  191. Copy Paste seeking help
  192. Shape's Index number?
  193. To position Command Bar
  194. dialogue box breaking loop code
  195. find a variable x-y position
  196. Code check to see if workbook open
  197. Combobox values reference to another workbook
  198. Using spreadsheet formulas in VBA code
  199. Run-time error '1004'
  200. Combo Box Problem in Excel 2003
  201. Find last row in sheet
  202. Time question
  203. Filter and Export Data-Workbook to Workbook
  204. Edit Range Password
  205. how to fill array of arrays?
  206. message box that closes its self
  207. querystring size limit
  208. excel and pdf
  209. Date difference
  210. A calendar in excel
  211. Weird problem
  212. How to code using the offset(x, x) with this ?
  213. Crosshairs instead of hand?
  214. '02 Excel Workbook to Workbook...HELP!!!
  215. Question about screen coordinates
  216. Closing / Opening Workbooks
  217. Creating a Macro for Cell Validation
  218. Timer in Excel
  219. deleting a variable number of worksheets
  220. Code behind Built In function
  221. Project library
  222. Looping
  223. Macro to sum automatically data during input
  224. Select rows with data
  225. contribution on email topics and question
  226. help with submenu
  227. How to tell if a worksheet is subtotalled
  228. changing cell colour using based on cell value
  229. Teacher needs design help: collect data 32 peer-peer to place into excel. Best way?
  230. Add sheet and rename it
  231. ComboBox question
  232. Transposing Row Data To A Column of Cells
  233. Copy "one to many" records to another worksheet
  234. Using info from one workbook into another???
  235. Having trouble with refering to arrays
  236. RE: Text Box
  237. Work marked late -Either VBA or Worsheet function?
  238. dates in arrays
  239. Running a macro by clicking on a worksheet tab
  240. Form question, please help
  241. function won't return value
  242. keep on assigning macro to buttons
  243. VB Question
  244. arrays - null
  245. restrict with rules
  246. Subtotal Function VB code
  247. Novice to Loops
  248. Find cell based on formula result and delete contents
  249. Group Lines?
  250. Extract unique rows and incremental copy