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. Updating cell references...
  2. selecting range
  3. macro for validating and highlight email ID wrongly formated.
  4. open csv file?
  5. Running a macro on file open
  6. Clipboard is EMPTY.
  7. Permutations - Combinations
  8. PasteSpecial-Values.
  9. speed up code
  10. Move to the row below
  11. Calendar
  12. Populating a text box in a form based on VLOOKUP function
  13. SCript to combine two workbooks by multi Criteria
  14. Monitoring cells using userform
  15. Sending Macros with a file
  16. Adding a text box to a chart with VB
  17. display contents of column A
  18. Macro
  19. Indexing?
  20. Userform refresh not showing
  21. ComboBox
  22. Userform moving text
  23. And(month,year) logic
  24. Adding code to a form on the fly...
  25. Custom VB Written Message for Protected Cells
  26. open folder
  27. Linking list box to option buttons
  28. Changing the datasource of a MSQuery query
  29. form validation
  30. Why wont my macro work
  31. Creating payslips
  32. Please help me and you will be blessed.
  33. Opening website, getting data, closing website
  34. Copying Data from workbook a to workbook b, many times
  35. computing weekly average
  36. Url
  37. Converting a forecasted value to a fixed value.
  38. External links...
  39. Listbox selection
  40. Rearranging Columns
  41. Highlighting a Row when a cell is selected
  42. Creating Multiple Hyperlinks
  43. Print Name Ranges
  44. manipulate sprdsht & trnsfr to Access
  45. Seletion of unknown range in EXCEL using macro
  46. Print contents of TextBox from UserForm?
  47. Calling a DLL from Excel.
  48. Restrict column adding and widening
  49. Insert MS Word Doc on condition
  50. VBA UDF Excel range bug?
  51. Summing a Column with Blanks
  52. stop at cetain row auto paste
  53. Exporting to Excel with ASP
  54. excel copy and paste visual basic
  55. Timing code executions?
  56. VS [2005] Code Problems
  57. if statement is true, add a point. if not, do nothing
  58. Date Match between WorkBooks
  59. Userform Problem
  60. Macro Security Message when opening file, but I've removed the macro
  61. Count
  62. Search for Value across multiple sheets of another workbook
  63. Combination of UDF, Worksheet_change, and copy/paste causes problem
  64. search statement
  65. Browse folder in Excel X
  66. Create Multiple Folders
  67. Assign a Macro to a cell
  68. Error Handling
  69. Find Msgbox code in VBA
  70. Problems with XLSheetVeryHidden
  71. looping through a selection
  72. Numbered Printout
  73. Database query - Access necessary?
  74. Determine create date of imported file
  75. Cell Highlight
  76. Hyperlinks and Sheet names
  77. Automatic Date Entry?
  78. Stop sub hopping
  79. replace column items
  80. Data from outlook to excel
  81. Replace whole words only
  82. Loop within a loop
  83. Moving to next column in code
  84. copying top 15 rows
  85. remove characters before "="
  86. look for a name on a worksheet
  87. Toolbars
  88. password box
  89. Userform Display Question
  90. drop/pull down list
  91. Open a New Workbook
  92. How not to activate between two files
  93. VBA for creating formula for entire
  94. worksheet toolbars
  95. Page breaks
  96. Converting Excel forms to a new layout
  97. Deleting a macro in thisworkbook
  98. Check Boxes / Radio Buttons
  99. Grouping Locked by Protection
  100. Runtime Error 80040e10 Excel VBA MS Access
  101. Remove the blue-window border on modeless userform?
  102. User To Open Data File ?
  103. Changing Values in ThisWorkbook
  104. Inserting rows and columns in protected sheet.
  105. Protected Toolbars Button Enabling Possiblity.
  106. Need help...please
  107. Extend Loop From Within ?
  108. Problems with macro
  109. Very New to Macro Coding
  110. Is this even possible?
  111. multiple If one nested then if overall result
  112. Addressing issues
  113. Copy PC MAC address to worksheet: how to get rid of MsgBox?
  114. use of wild card in file name.
  115. Displaying The Active Sheet Name In A Cell ...
  116. Array Help Needed
  117. wanting to know, please someone
  118. file update notice
  119. Newbie Info
  120. 2 OptionButtons in the same Frame
  121. vlookup #N/A
  122. Workbooks.OpenText Fieldinfo
  123. Name sheets from adapted cell values
  124. Protecting my Code
  125. Hiding columns that fit a criteria
  126. Weird counter question
  127. Want to run macro that updates part of a formula reference
  128. Multiple Numbered Variables P1 - P 63
  129. Conditional Hyperlinks?
  130. Code Protecting Sheets, Possible?
  131. Triggering Worksheet Events
  132. Bypass username/password prompt when executing an excel web query
  133. Sum Help
  134. Progress Bar
  135. How to sort this worksheet
  136. Searching text and assign a category problem.
  137. Placing a formula into merged cells!!!
  138. show info from access in excel
  139. Running a macro if more than one cell changes?
  140. Find cells then insert cells between them
  141. VBA project protection
  142. Sorting by dates
  143. Runtime error 1004
  144. edit the registry
  145. Getting numeric value from integers mixed with strings
  146. Simplifying code
  147. Sending CDO mail to external users
  148. Adding to a current cell value
  149. msg box multiple lines
  150. auto align
  151. How to create navigation buttons
  152. Extremely new to VBA coding
  153. Register DIY add-in
  154. Hide rows based on Cell contents
  155. Very Difficult & Detailed Macro to find Duplicates
  156. Button Clicked
  157. Runtime error 1004,
  158. delete range based on value outside range
  159. Using array data for copying ranges to new sheets!
  160. Deleting a selected row
  161. Form and Database Question
  162. IP address range formula in excel
  163. appointments in Outlook from Excel
  164. Validation Of Textboxes In A Form
  165. Sorting rows by Color Index of cells
  166. Extending a Macro
  167. Comparing Columns
  168. Entering a value into a cell by clicking
  169. Data validation code embedded thru .Net Program
  170. Run-Time error '424'
  171. Chars in macro
  172. problems with Win32::Ole to access/execute some macros/functions.
  173. sorting out columns
  174. Problems with VBA-pivot
  175. Scroll bar
  176. changing resolution
  177. cross tab charting and pasting
  178. i am a rookie
  179. VBA value reference from a cell ..simple question
  180. Attach external file to PDF from Excel
  181. Problem in using check box combination
  182. Formatting a variable used in a message
  183. Macro?
  184. How to discover the color...
  185. VBA - how to get row number?
  186. Formula help
  187. load Dll
  188. Result arrives... and disappears !
  189. Changing background color of a combobox list entry
  190. Compare two excels sheet
  191. Copy and Paste to other sheets
  192. Can Macros create Macros?
  193. Display Access union query results in excel
  194. VBS Find/Search Button
  195. copy range from A worksbook to anohter workbook
  196. AdvancedFilter with no criteria
  197. Macro Disappear
  198. Copy several sheets in the same workbook to new workbook
  199. duplication with lastName split and a twist :)
  200. Programming Formatting?
  201. Menu and Toolbar Generation.
  202. run at open
  203. Macro code to find out if a value is one of the values in a list
  204. Fill column
  205. chart of max values from 50 cartesian data sets
  206. Is There A Better Way?
  207. VBA Code to duplicate (create copy of a sheet) sheets?
  208. unmerging merged cells
  209. total width of all visible, contiguous columns occupied
  210. Move to next cell (not adjacent) for data entry
  211. Useful code that deletes entire rows based on formatting
  212. bit of a problem
  213. Save As dialog box
  214. keyboard shortcut to run Sub(module in VB)
  215. Refreshing a query in excel
  216. How to secure a workbook.
  217. How to create menu of worksheet names?
  218. Shortening Code
  219. Shortening Code
  220. How to put an entire Sheet into a variable?
  221. Simple Query
  222. Matrix Elimination and Substitution?!
  223. Multi Colour Conditional Formatting on calculate
  224. Print and move cells up
  225. Slow Save
  226. Help on VB code
  227. Shapes problem
  228. Need Help On Combobox
  229. Custom h:mm formatting Macro help
  230. Visual Basic Run Time Error "1004"
  231. help - emailing data from excel
  232. Excel formating and RDBMS
  233. Textbox invisible on userform
  234. Variable Value to Replace Reference in Filename?
  235. Printing from a UserForm ListBox
  236. Macro - input sheet selection
  237. How to define if a specific cell changed?
  238. Maximum criteria??
  239. Regional Date Format
  240. ComboBox DropDown
  241. Compile Error?!?
  242. Applying a Macro to multiple worksheets
  243. command button to refresh imported data
  244. Create Macro for repeat use or for others to use?
  245. Maximize on open
  246. simple VB
  247. Access data open using button
  248. Listbox to be Alphabetically sorted
  249. Changing sheet protection
  250. Finding an instruction in a macro