Create Error Message on Text Input Box

A

asmith988

New Member
Joined
Oct 11, 2017
Messages
3
Hello and thank you in advance for reading my post and attempting to help me.

I have created a macro for my housekeeping department in which I would like to be able to type in one of my housekeeper's names and have my macro bring me directly to their data in my spread sheet. However, I also want a message to pop up if I or another user types in a wrong name or a misspelling since I won't be the only one using this.

At first, if I typed in a wrong name, nothing would happen; the input box would just go away. So I wanted a message to come up if to let me know I did something wrong.

Then, I managed to create an error message but now my problem is that it comes up EVERY time whether it's an actual error or not. (So annoying.) Obviously, I only want the Error message to come up if there isn't an actual match to my input.

Any help?

Thanks a bunch!
-A. Smith

Sub ACTIVATEHOUSEKEEPER()
Dim inputData As String
On Error Resume Next

inputData = Application.InputBox("Enter Housekeeper's Name. (Upper Case Only)", "Input Box Text", Type:=2)
If Error <> inputData Then
MsgBox "Error"
Else
End If

If inputData = "YARITZA" Then

ActiveWindow.ScrollColumn = 7

ElseIf inputData = "MARILUZ" Then

ActiveWindow.ScrollColumn = 12

ElseIf inputData = "KYANDRA" Then

ActiveWindow.ScrollColumn = 17

ElseIf inputData = "KELLY" Then

ActiveWindow.ScrollColumn = 22

End If
End Sub
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
Try this
Code: 
Select Case Application.InputBox("Enter Housekeeper's Name. (Upper Case Only)", "Input Box Text", Type:=2)
    Case "YARITZA" 
        ActiveWindow.ScrollColumn = 7
    Case "MARILUZ"
        ActiveWindow.ScrollColumn = 12
    Case "KYANDRA"
        ActiveWindow.ScrollColumn = 17
    Case "KELLY" Then
        ActiveWindow.ScrollColumn = 22
    Case Else
        MsgBox "error"
End Select

Note that both this and your code are case sensitive.
 
Upvote 0
Welcome to the MrExcel board!

I understand that you now have you code working but I have a few comments/suggestions.

1. As a user I would find it quite annoying to have to type the name in upper case. My suggested code below allows the user to use any combination of case, so long as the spelling is correct.

2. If an incorrect name is entered, as well as having to click the message box to get rid of it, the user also has to re-trigger this code (by a button or something I guess). My code suggested code simply pops up the ibput box again with a slightly changed prompt telling them they have not entered a correct name. If the user changes their mind and doesn't want to enter a name at all, they can click the Cancel button or the top right cross.

3. Since your housekeeper areas are all the same size (currently 5 columns apart) you don't need to set separate code for each scroll column.

4. If you change the number of HKs or what column the first HK is in or the number of columns per HK, the code below is more easily adapted than you original structure just by altering the relevant 'Const' line(s)

Rich (BB code): 
SSub ACTIVATEHOUSEKEEPER()
  Dim inputData As String, Prmpt As String
  Dim Housekeepers As Variant
  Dim HKNum As Long
  
  Const ColsPerHK As Long = 5                                     '<- Number of columns per HK
  Const FirstCol As Long = 7                                      '<- Column for first HK
  Housekeepers = Array("YARITZA", "mariluz", "KYANDRA", "Kelly")  '<- List of HKs (case doesn't matter)
  Prmpt = "Enter Housekeeper's Name"
  Do
    inputData = Application.InputBox(Prmpt)
    If UCase(inputData) = "FALSE" Then
      MsgBox "OK,cancelled"
      Exit Sub
    End If
    On Error Resume Next
    HKNum = Application.Match(inputData, Housekeepers, 0)
    On Error GoTo 0
    Prmpt = "Incorrect name, please try again"
  Loop Until HKNum > 0
  ActiveWindow.ScrollColumn = FirstCol + (HKNum - 1) * ColsPerHK
End Sub
 
Upvote 0
Dear Peter,
This is SOOOOOOO Awesome! I had no idea something like this could exist. It cuts down on my long lists of codes. Thanks so much!!

But, I was wondering, is there a limit to how large my spreadsheet can be? I added all my housekeeper's names to the spreadsheet and everything works perfectly until the last two names starting on column BO.

Thanks in advance for your help!

-A. Smith

Code: 
Sub ACTIVATEHOUSEKEEPERmrexcel()
  Dim inputData As String, Prmpt As String
  Dim Housekeepers As Variant
  Dim HKNum As Long
  
  Const ColsPerHK As Long = 5                                     '<- Number of columns per HK
  Const FirstCol As Long = 7                                      '<- Column for first HK
  Housekeepers = Array("YARITZA", "MARILUZ", "KYANDRA", "KELLY", "MARIA", "ANA", "ENEDELIA", "SIMONE", "MARINA", "ERIKA", "GRISELDA", "DEJA", "LOURDES", "APRIL", "OTHER") '<- List of HKs (case doesn't matter)
  Prmpt = "Enter Housekeeper's Name"
  Do
    inputData = Application.InputBox(Prmpt)
    If UCase(inputData) = "FALSE" Then
      MsgBox "OK,cancelled"
      Exit Sub
    End If
    On Error Resume Next
    HKNum = Application.Match(inputData, Housekeepers, 0)
    On Error GoTo 0
    Prmpt = "Incorrect name, please try again"
  Loop Until HKNum > 0
  ActiveWindow.ScrollColumn = FirstCol + (HKNum - 1) * ColsPerHK
End Sub

[TABLE="width: 5129"]
<tbody>[TR]
[TD="class: xl73, width: 103, bgcolor: transparent"]SEP 2017
[/TD]
[TD="width: 410, bgcolor: transparent, colspan: 5, align: left"]
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>

<tbody>
[TD="class: xl89, colspan: 5"] DAILY TOTALS
[/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 4"]YARITZA
[/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 3"]MARILUZ
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 3"]KYANDRA
[/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 270, bgcolor: transparent, colspan: 3"]KELLY
[/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 180, bgcolor: transparent, colspan: 2"]MARIA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 180, bgcolor: transparent, colspan: 2"]ANA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 270, bgcolor: transparent, colspan: 3"]ENEDELIA
[/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 180, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl74, width: 270, bgcolor: transparent, colspan: 3"]MARINA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 2"]ERIKA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl87"][/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 3"]GRISELDA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl87"][/TD]

</tbody>
[/TD]
[TD="class: xl74, colspan: 2"]DEJA
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl87"][/TD]

</tbody>
[/TD]
[TD="class: xl75"]APRIL
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="width: 90, bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl75"][/TD]

</tbody>
[/TD]
[TD="class: xl74"]OTHER
[/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl75, width: 90, bgcolor: transparent"][/TD]
[TD="class: xl87, width: 90, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl80"]DATE
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl65"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[TD="class: xl66"]STY OVR
[/TD]
[TD="class: xl67"]CHK OUT
[/TD]
[TD="class: xl65"]HRS WRK
[/TD]
[TD="class: xl65"]HRS ALW
[/TD]
[TD="class: xl68"]HRS VAR
[/TD]
[/TR]
[TR]
[TD="class: xl81"]10/01/17
[/TD]
[TD="class: xl86"]53.00
[/TD]
[TD="class: xl86"]33.00
[/TD]
[TD="class: xl86"]29.75
[/TD]
[TD="class: xl85"]10.75
[/TD]
[TD="class: xl72"]19.00
[/TD]
[TD="class: xl69, bgcolor: transparent"]7
[/TD]
[TD="class: xl70, bgcolor: transparent"]7
[/TD]
[TD="class: xl71, bgcolor: transparent"]7.50
[/TD]
[TD="class: xl82"]5.25
[/TD]
[TD="class: xl82"]-2.25
[/TD]
[TD="class: xl69, bgcolor: transparent"]14
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"]3.25
[/TD]
[TD="class: xl82"]3.50
[/TD]
[TD="class: xl82"]0.25
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69, bgcolor: transparent"]9
[/TD]
[TD="class: xl70, bgcolor: transparent"]6
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"]5.25
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69, bgcolor: transparent"]8
[/TD]
[TD="class: xl70, bgcolor: transparent"]6
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"]5.00
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69, bgcolor: transparent"]7
[/TD]
[TD="class: xl70, bgcolor: transparent"]7
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"]5.25
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69, bgcolor: transparent"]8
[/TD]
[TD="class: xl70, bgcolor: transparent"]7
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"]5.50
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl69, bgcolor: transparent"]7
[/TD]
[TD="class: xl70, bgcolor: transparent"]7
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"]5.25
[/TD]
[TD="class: xl88"]HRS WRK
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[/TR]
[TR]
[TD="class: xl81"]10/02/17
[/TD]
[TD="class: xl84"]28.00
[/TD]
[TD="class: xl84"]15.00
[/TD]
[TD="class: xl84"]14.50
[/TD]
[TD="class: xl83"][/TD]
[TD="class: xl72"]14.50
[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl69"]10
[/TD]
[TD="class: xl70"]6
[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"]5.50
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69"]14
[/TD]
[TD="class: xl70"]3
[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"]5.00
[/TD]
[TD="class: xl82"]HRS WRK
[/TD]
[TD="class: xl69"]4
[/TD]
[TD="class: xl70"]6
[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"]4.00
[/TD]
[TD="class: xl88"]HRS WRK
[/TD]
[TD="class: xl69"]10
[/TD]
[TD="class: xl70"]6
[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"]5.50
[/TD]
[TD="class: xl88"]HRS WRK
[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl88"][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Sorry, I must have missed the notification about your reply here. Your problem with the last two names is that in your modified code, the third last name is "LOURDES", but your data does not have a set of columns for that person. You would need to either:
- Remove that name from the list in your code, or
- Add in a set of 5 columns (between DEJA & APRIL) for that housekeeper
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Macro stops after message box appear
Replies
3
Views
479
bobsan42
bobsan42
M
  • Question Question
VBA error not making sense
2
Replies
10
Views
213
Skyybot
Skyybot
B
  • Question Question
Error message when copying and renaming a worksheet
2
Replies
13
Views
296
smozgur
smozgur
K
  • Question Question
Convert a user form TextBox input to numerical value long or date
Replies
2
Views
244
Kappes105
K
C
  • Question Question
Create Folder Using VBA
Replies
8
Views
306
CainyUK
C

Forum statistics

Threads
1,223,885
Messages
6,175,187
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top