PDA

View Full Version : Excel Help



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

  1. How To Filtering Datas On a ListBox By First Date and Last Date?
  2. Opening all worksheets in a workbook
  3. Solved: Forcing Conditional Formatting to Check Cell's value
  4. Solved: Show text from textbox on worksheet in textbox on userform
  5. Inserting Table into word from Excel VBA
  6. Solved: Line to close simple window
  7. Auto populate drop down box
  8. form - fullscreen
  9. Solved: search for first blank cell then paste clip board across sheets
  10. Paste selection as Message Body
  11. Solved: Set page as default tab
  12. Solved: how to define the cells?
  13. Solved: Defining a specific cell range
  14. Solved: Getting TextBox to display multiple Vlookup's on Combobox change?
  15. Two Parameters in a web query
  16. help altering recorded code please
  17. Solved: Show if no setting
  18. Solved: Conditional Formating by VBA creates its own condition
  19. Solved: Workbook links need password
  20. Cut & Paste Error, Excel Hang?
  21. Solved: Allow user to set Percentage
  22. How to modify only visible cells
  23. Solved: Formula for incrementing a number in the middle of text?
  24. switch to a .exe installer
  25. Color picker
  26. Excel 97 & 2000 Compatibility??
  27. Solved: Vlookup + ISBLANK?
  28. Solved: Capture picture, save to folder and create hyperlink in cell?
  29. Solved: Allow users to set default save directory.
  30. Solved: Convert chart into a insert comment picture
  31. Solved: CheckBox
  32. delete form
  33. How to Create folder in Web/sharepoint
  34. Solved: InStr Error when using .Comment.Text
  35. VBA Help
  36. Help with speeding up a macro
  37. how to autoadjust the size of a cell in a worksheet?
  38. This code errors out
  39. Collecting list of Photos and hyperlinking to them?
  40. Solved: Combine Non-Contiguous Ranges Hide Col.
  41. Use cell value to search for a file & Copy/Paste?
  42. Advice: Extract Embed Flash file in Excel / Word
  43. an empty textbox in a formula
  44. Solved: Macro to Email Excel workbook
  45. Solved: VLookup problem when using QueryTables.Add
  46. Entering a date between 2 parameters
  47. Solved: Text box Date Calculation Error - Type Mismatch
  48. Solved: Delete Rows based on Criteria
  49. Solved: HOw to make a dynamic bar diagram?
  50. When "idle" Excel workbook opens Visual Basic Editor
  51. Progress bar indicater
  52. Solved: set User Names to an array
  53. Solved: Copying unsorted data to a sorted order in a new sheet
  54. Issues showing userform with Excel 2000 (service pack 3)
  55. Use icon from network drive for desktop shortcut
  56. I want my macro to do the same thing in 25 folders...
  57. Dont allow users to select same in List Boxes
  58. Solved: Formula Results are #N/A because od no data
  59. Help: Seperate data and insert new rows
  60. Hiding sheet after copy same sheet into new workbook
  61. Extract Access Table Names
  62. Solved: Click Cell Insert Check Mark
  63. Solved: Formula error
  64. VBA cut-and-paste code stopped working 100%?
  65. print colour
  66. print-out time
  67. Sum using match feature with multiple criteria
  68. Solved: Textbox Format Value
  69. VBA Help
  70. AutoFit of Merged Cells
  71. Solved: Please help to alter some existing code
  72. Solved: Vlookup formula for unique entries in lists in cells in range?
  73. Solved: Case Select
  74. Solved: Can a form have data referred to another sheet
  75. Return List of Folders Containing a Specific Word
  76. Solved: Sorting Multi Arrays
  77. Solved: List Box question that I can't find answer to
  78. Solved: How to Search the Latest Date in a Worksheet
  79. Solved: Worksheet Protection Vs Macro
  80. Solved: excel/outlook create a "line-break"
  81. Solved: How To Automaticly Close A Workbook If Nothing Changed In 15 Minutes?
  82. Truncating Array Results in a List Box
  83. msgbox automatically clicks yes
  84. chk and paste the range
  85. Solved: Next Row in Spreadsheet
  86. Solved: Anybody know how to speed up subtotals?
  87. Solved: Selection.End Complile Error: Method or Data Member not Found
  88. Multiple users
  89. Advice how to edit values in non-contig. range
  90. Updating data in summary sheet
  91. Form Help
  92. Connecting To A Database Without The Local Machines Odbc
  93. Email Selection
  94. Solved: Form Help
  95. Auto_open failure
  96. Using ActiveX Objects in Excel
  97. Procedurally generated checkbox code
  98. Help Setting which workbook a Macro will run
  99. Merged Columns
  100. checkdic as dictionary
  101. Solved: ListBox Columnwith
  102. problem in a form
  103. Solved: Only allowing values to be copied between certain dates?
  104. Help with making code more flexible
  105. Form List Help
  106. Solved: Is there any tooltiptext in excel?
  107. Solved: Sub Menu in My Custom Menu
  108. Solved: Build list of sheet names and create cell validation?
  109. Excel to SQL Connection?
  110. Transferring to VB.net
  111. Conditional Copy of Data using the macro
  112. Solved: Display Picture in frame on userform follwing hyperlink?
  113. Solved: Shorten this VBA code
  114. Solved: Mask in form
  115. Solved: If value "tick mark" then ...
  116. Locking embeded word object in excel
  117. Solved: variables in formulas
  118. copy range to diffrent book
  119. same code does not workon diffrent sheet with same type of data
  120. Solved: Versatile Form
  121. Running a macro for any workbook/worksheet
  122. Coding of userform
  123. Save Workbook on Webpage
  124. Solved: Trimming "Leading" spaces from cells in VBA?
  125. Solved: printing a dynamic named range problem with non contiguous data?
  126. Solved: Email code crashes if workbook isn't saved
  127. Prevent two network users from opening same workbook?
  128. Userform to Macro
  129. Solved: Adding Txt Boxes in Form
  130. Solved: More than 2 criteria - possible??
  131. Solved: Combining cells using a function key
  132. Userform, Textbox data validation
  133. Telephone Dial
  134. Solved: how to empty combobox?
  135. loop that add lines alternately
  136. Solved: Run Time error 1004
  137. Solved: Save As
  138. Simple Filter
  139. Copying Custom Menu to another Computer
  140. Solved: Set Slider to Current Year
  141. "Picture too large/truncated" error?
  142. If-Then
  143. Found some interesting code:
  144. Interactive selection of worksheet and range
  145. Copy certain range from the sheet matching conditions
  146. Run time error '1004':Select method of worksheet class failed
  147. Solved: Locate max number from column A
  148. Date Wise Max code
  149. Macro to generate documents from database
  150. Solved: Make list boxes visible=False
  151. Querying from Access
  152. Solved: Thinking outside the Square
  153. Header Problem with "text CC F&B"
  154. Formula in a Control
  155. Solved: Worksheet_Calculate event
  156. If Txtbox equals Chr then Show Image
  157. Calling a UserForm when a user clicks a cell
  158. BeforeDoubleClick Event
  159. Extracting max & min values with a condition
  160. UserForm Concept help
  161. Search a Userform Listbox for matching text from another Listbox
  162. Solved: Web browser control
  163. Search for the string and move the cells accordingly
  164. Solved: Cut from Word and paste in Excel
  165. Solved: Help with this code?
  166. Solved: Downloading XLS files from Web page
  167. Calculate doesn't seem to do anything
  168. Advance Filter with command button
  169. how to define color of the cell by coding
  170. open worksheet
  171. Named Ranges in Excel VBA
  172. Solved: simple problem im sure
  173. Solved: Internal rate of return Function
  174. Auto Filter
  175. Solved: Please Help - Major Problem
  176. Solved: Version Control
  177. copy and paste to new row
  178. send Registry Settings with email
  179. Help... I am so lost
  180. Getting data from diferent files in same Folder
  181. Solved: Formula to Script
  182. Checking Textboxes
  183. Solved: Analog Clock
  184. Solved: Help AutoFilter 2 criteria at one time
  185. macro to print payslips
  186. Removing Toolbar etc
  187. Solved: Writing to VBE crashes Excel
  188. USER FORM - lots of small problems - PLEASE HELP!
  189. Check and Transpose
  190. Solved: Problem With A Text Box On A Chart
  191. Tabulation Form
  192. Removing #na from excel cell
  193. Printing Comments
  194. Solved: Match two criteria and display offsets? worksheet function
  195. Sporadic Error 1004 when creating a pivot table
  196. Controling WebBrowser font size
  197. Form vb change help
  198. Solved: AddItem help
  199. Solved: Combining Arrays
  200. Referencing a Workbook
  201. Solved: Search Excel File and populate Web page
  202. Reading a csv file using vba excel!
  203. Consolidated Messages/Strings
  204. Transfer Data From Excel to Access Table
  205. Addin to display under a menu
  206. Solved: Copy Columns and paste in different sequence
  207. Solved: how to use match property of the worksheetfunction class?
  208. Solved: Cut and copy new approach
  209. Solved: Vlookup loop
  210. Solved: conditional formating offset
  211. Solved: apply end of cell to paste
  212. Solved: Copy Data that meets criteria
  213. Solved: A Loop To Create A Worksheet Formula
  214. Solved: Form to Spreadsheet problem
  215. Solved: Two versions of one project -- oops!
  216. Tick appropriate box
  217. Userform vs controls in worksheet
  218. Solved: multipage page selection?
  219. Error 400
  220. Solved: Loop Help
  221. how to show 4 digit number
  222. subtotal at pagebreak
  223. Show todate as default
  224. msgBox with a Text Box Input
  225. Allow user to set Button Caption
  226. Private Sub userform_load()????
  227. event driven actions in repsonse to data
  228. Solved: loop, find value and replace assistance
  229. Solved: Print Prompt For Form
  230. SUM(IF across multiple sheets in another workbook
  231. Solved: I need fixed decimal
  232. macro to set expiry date
  233. Phone dialer sheet is attached
  234. Solved: Mixed Date formats
  235. very simple one
  236. Form If Statement
  237. currency in a concatenated string
  238. import outlook calender automaticly using vb
  239. Solved: TOOLBAR -> HELP!
  240. Extracting multiple max & min values from a column
  241. Solved: conditional format date
  242. Range format
  243. Drop down query
  244. Userform to do Filter Mode
  245. Userform to use a PIVOT
  246. Solved: If a cell is full
  247. User form and tab key
  248. Extracting Word From String...
  249. Solved: Indirect reference for form controls
  250. Deleting Rows w/ specifics datas