strange behaviour

  1. P

    Listbox behavioural problems (Resizing)

    Hi, I'm stuck at the moment with a problem with a listbox on a userform being a pain in the proverbial. I'm using the RowSource method to populate the listbox (really only because I want proper column headers rather than labels above, although I might revert) The listbox loads up ok, but then...
  2. C

    strange result - Nested IF statement

    A B C D E F G H Reporting Date Invoice ID invoice payment id invoice header id invoice terms date vendor number po/non-po flag supplier name 23-Apr-20 1900057573_5430_2020_0001064077 1900057573_5430_2020 0001064077 NON_PO GT TRANSPORT 2012 CO LTD 23-Apr-20...
  3. J

    ActiveWorkbook.Save macro causing no edit capability

    Hello, I have an Excel workbook with 3 worksheets, running Excel 2016, where upon start-up I run a macro (in ThisWorkbook) to hide the ribbon and formula bar. Private Sub Workbook_Activate() Dim ws As Worksheet Application.ScreenUpdating = False Application.ExecuteExcel4Macro...
  4. C

    Macro acting funny

    Hi, I have a macro that imports a text file, cleans it up, and transfers the information to a printable data sheet for processing. It works great for %99.9 of my users. I have one guy who just transferred from excel '14 to '07 (which is the format my software is formatted for). When he runs...
  5. savindrasingh

    Can For Each change cell contents without any code to do so?

    I am facing a strange problem with For Each Loop. While debugging my code I have found that as soon as I enter the line highlighted below (having For Each Associate In empList) it is changing the cell contents with user's display name without even running the code? It is so strange, I am not...

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