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 164 165 166

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