MrExcel Message Board

This Week's Hot Topics

• Finding issue in If elseif else with For each Loop

  • Started by Arunachaljois
  • Aug 1, 2020
  • Replies: 57

  Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• VBA to copy certain columns from multiple workbooks with multiple worksheet based on criteria into master workbook

  • Started by nathanmav
  • Sunday at 9:06 AM
  • Replies: 38

  Hi everyone, I would like to ask for help about the code I found and I tried to modify it but I'm not lucky to make it work. I have a total of...
• Frequent Text - Duplicates

  • Started by SaraWitch
  • Aug 1, 2020
  • Replies: 30

  Hello all, I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula...
• Timer in VBA - Stop, Start, Pause and Reset

  • Started by Anton1999
  • Wednesday at 3:27 AM
  • Replies: 28

  [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox

  • Started by jaym6939
  • Wednesday at 12:28 AM
  • Replies: 26

  Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Multiple Case statements

  • Started by davidausten
  • Tuesday at 12:59 PM
  • Replies: 26

  Im using a combo box to select the option. The thing I am having trouble with is that if you select the second case statement from the list (they...