private worksheet_change

  1. L

    Help to combine two Private Sub Worksheet_Changes

    Hi, I am using VBA to automate values in a specific column for a tracking sheet. It works great but as always is the case I am wanting more. Can anybody help me reorganise these 2 pieces of code so that they work simultaneously in the same worksheet change? Here is the code: Private Sub...
  2. L

    Data validation list and Vlookup in VBA, to input, on cell change, if/vlookup formula referencing cell that was changed

    Dear Excel Guru’s I’m struggling with one of my last tryouts in Excel Macros. I would like to have in my sheet combination of Data validation list & Vlookup. But I want to have it in Macro, so user won’t be able to see formulas, delete, edit etc.. I succeed with stand-alone Macro (what was...
  3. E

    Two Private Worksheet_Change

    Hello. I'm new to VBA language. I have 2 Worksheet_Change routines that work fine by themselves,but i need to put them both in the same sheet. I know that there can be only one per sheet, so I guess that the only way is to bind both routines into one, but I don't know how... First one...

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