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. Hyperlinks
  2. Locate available FTP port
  3. Save prompt with csv files
  4. Decimals
  5. flitering
  6. retrieving database entry into another wsheet
  7. Isnumeric function
  8. mixed data
  9. CheckBox group name
  10. Automatic simple calculation for dummy
  11. The borders of the selected range
  12. highlight the cells
  13. Add dialog's
  14. Starting a Macro using App.Ontime
  15. Calculations in undetermined number of row??
  16. Create a macro to change cell content
  17. sheet contents comparison
  18. Use macro to activate Design Mode
  19. Find Numbers
  20. Macro - Hiding Columns determined by cell values
  21. SendKeys not working from userform
  22. tweak code for excel 2007
  23. Increment cells in column by 1
  24. Save As
  25. Automated graph production
  26. Loop to do Func for each Cell in Column
  27. How to create multiple timer in vba?
  28. Overwrite existing workbook without prompting
  29. Setting width of FlexGrid in VBA
  30. UDF for cell position
  31. Save As
  32. DOS command in VBA
  33. Q Filtering Windows operating system
  34. Extracting data from a grid
  35. Selecting YES or NO on sheet save
  36. Subtotals based on column change
  37. Send shapes back automatically
  38. Hypelinking macro
  39. Pointing out cells based on critiria
  40. -2147467259 Date provider or other sevice returned an E_FAIL status error
  41. Need help with Visual Basic plezzz
  42. Unprotect Issues
  43. Stop messages appearing during macro
  44. Urgent!!!
  45. Refreshing Web Query Macro
  46. Creating list of values which appear more than once in a column
  47. Bizarre command button problem
  48. Passing a drive letter as a variable
  49. static global variable?
  50. Using Outlook from Excel.
  51. Error retriving data from Access
  52. If statement too long
  53. Currency Symbols From SQL into Excel become "corrupted"
  54. How to change a Command Button caption from "Enable" to "Disable"?
  55. saving, deleting data, macro
  56. Please HELP me with changing chart values from a Macro.
  57. Temporarily exiting a program
  58. Macro assigned to menu not found
  59. Hiding sheets based on value in dropdown cell
  60. delete rows based on 2 criteria
  61. Search multiple terms through excel
  62. Changing Color
  63. Generate pdf or word files of a receipt from different suppliers
  64. Header
  65. Data connection from different sources
  66. protect the rows
  67. code for wrap text
  68. Excel search
  69. Error Message
  70. Import data from Excel worksheet to database
  71. "this workbook"
  72. Range in macro.
  73. Cannot connect to Access database
  74. Protect wooksheet
  75. How do I copy all comments back to their own cells....?
  76. Data from external file in Excel Report
  77. faster find method
  78. Message box/Userform help
  79. #VALUE! when generating excel worksheet and using ado
  80. How to delete line under your find...
  81. fi ding a value and then selecting entire colum
  82. Mapping a networkresouce
  83. Data report in excel
  84. macro search bombing out
  85. Operating on a range not in activesheet
  86. Next Sheet
  87. ListBox - start at the right line
  88. VBA- SaveAs filename and add
  89. Updating graph range in macro
  90. Deleting personal macro
  91. Subtracting Date and Times Question
  92. Posted on another forum >> Stopping a Macro When an Event Occurs
  93. Copy from 1 workbook to another
  94. Using a variable as an object name in a loop
  95. macro "double check"...
  96. Selecting a graph using macro
  97. Populate data on another worksheet
  98. macro - creating URLs
  99. Cross post - Can variables be part of an excel file address?
  100. Hiding Sheets and Macro Buttons
  101. Connecting to password protected MS Access through Connection String
  102. Cell values- macro issue
  103. Switch off Autofilter thru macro
  104. Range name in a formula
  105. How to create Pivot Table and Pivot Chart in VBA
  106. Excel help page file name and context ID.
  107. Macro Speed
  108. Dynamically change list in a userform
  109. Dropdown question
  110. Open Excel Automatically
  111. Unable to Text to columns due to data size
  112. Checkbox relating to datestamp.
  113. Stacking the Contents of Multiple Sheets to One Sheet...
  114. Excel 03 & CTime converter?
  115. complex compare and align data help.
  116. Editing Comments
  117. Handling of multidimensional array in Excel
  118. Copying of data, with Row Jump
  119. saving as
  120. updating the value of a userform label
  121. Textbox value
  122. Syntax of Range
  123. Sheet not maximising
  124. Column to Row
  125. depressurisation time calculation
  126. Lost data in Import External Data
  127. A BIG THANK YOU to Leith Ross
  128. macros for data sorting
  129. Creating Job Calendar
  130. Macros with protection problem
  131. Hide workbook title bar when WindowState = xlNormal
  132. Retain color when transferring code from VBE to Word
  133. Code for suppression of Windows Warning messages
  134. SenKeys Issue
  135. Workbook_AfterSave()
  136. automatic emailing of records in a worksheet
  137. Copying cells using loops
  138. Rename Charts
  139. macro to copy value from 1 sheet to another
  140. Copy textbox from one worksheet to another workbook
  141. Not Enough System Resources to Display Completely
  142. macro to save to new workbook and clear sheet
  143. Select rating
  144. Export Excel Shape to Word
  145. dynamic arrays, redim preserve
  146. Character count
  147. Setting Variable to Count Rows?!?
  148. Data seems not to be refreshing
  149. Conditional Formatting Objects
  150. Setting a Variable Print Area
  151. Array Dump
  152. Counting Rows based on 2 Columns (Distinct)
  153. Macro's name
  154. Type Mismatch
  155. How do I code to prevent user skipping a control?
  156. Can I protect/lock only the cells containing formulas?
  157. error message
  158. Simulate 10000 binary vectors(marginal probabilities p1=.01,p2=.04, correlation=0.27
  159. Get Hard Drive Serial Number?
  160. Currentregion and/or range naming
  161. copy worksheets to new workbooks
  162. Print Listbox contents
  163. Run error 48
  164. Equally Spread Workload
  165. CheckBox and Combo Box
  166. macro replacing data - want to overwrite
  167. Cannot find macro
  168. Posted on more than one Forum >>Copying Data From One Sheet To Another
  169. Extract data from another worksheet
  170. Macro: Subtotal
  171. How to display different charts according to user input
  172. Find the last row of the particular spreadsheet
  173. Sort by text length
  174. Hide Autoshape
  175. If Statement in a Range
  176. Macro to grab webpages
  177. Where do I start (Ranking objects)?
  178. Macro to enforce cell shading before merging?
  179. Update Worksheet using an offline workbook?
  180. vb Date
  181. macro input formula
  182. Move two cells up if condition met
  183. Import Code Module
  184. selected option button assign 1 to a cell and others 0
  185. Detect Print Preview
  186. Filter
  187. Unique Password Generator
  188. Formatting
  189. Row number equal to formula in macro
  190. Convert PDF to Excel
  191. Run a macro when a user clicks in a certain cell
  192. Text Box on sheets
  193. Saving Results
  194. Records in Form
  195. Format Cell in UDF
  196. variables problems
  197. Macros
  198. Macro move folder and rename
  199. Remove formulas to downsize the workbook
  200. using loops to search through text files
  201. Copying without the formulas
  202. selecting cells
  203. macro works in 97&2000 but not 2003
  204. White numbers with words
  205. Question on Source of Run-Time Error
  206. Maximum number of macros??
  207. Convert formular to text
  208. Microsoft Query Wizard not previewing certain columns
  209. FYI - VBA in Office 2008 for Mac disappears
  210. Changing text box control sources via combo box values
  211. VBA Text Boxes
  212. Locked posted on more than one forum>Remove fields of strange Social Security numbers
  213. Copy cells
  214. How to find and extract numbers that may be present in lengthy text strings
  215. Create a new tab when entering value into a cell
  216. Range Name different depending on the sheet I view
  217. problem using ado to insert record into excel table
  218. Altering ranges in other worksheets without selecting them
  219. Macro to automate filter >= "inject todays date here"
  220. Email
  221. If AutoFilter is set, do this
  222. Error 1004
  223. Sum Formula
  224. searching excel for specific words
  225. How to find a number or text in the selected range
  226. Make a control required before user can move on
  227. Extract Unique Items
  228. VBA code that captures the Enter or Tab key when exiting cell #1 and set the focus on
  229. copy value of cell into a separate worksheet saved as another excel worksheet
  230. Counting Matches using AutoFilter
  231. Sorting Data With VBA
  232. Conditional Copy Paste function
  233. Copy UserForm while working in VBE?
  234. Locked as a cross post >> naming a selected range
  235. Disabling a Custom Tool Bar Menu down the tree
  236. simple while loop to adjust values in cells
  237. Issue trying to retrieve records from excel database
  238. Move data into empty rows when i delete old data
  239. Access to ranges in hidden sheets
  240. Frequency of two criteria
  241. Drop Down to Open Internet Link?!?!?
  242. Copy and paste massive data
  243. Application.Run
  244. onAction call sub with parameters
  245. SQL Query to VBA
  246. Auto_Close MsgBox
  247. Allow Percent in Textbox
  248. Hyperlink To Open Workbook and Particular Tab (Sheet)..Possible?
  249. protecting a workbook
  250. Using INDIRECT function on closed files without having to open them