event change vba

  1. E

    How can I use event`s with a Personal Workbook macros

    I have a situation where I am trying to use a Personal workbook macros but the event is trigged by the current open workbook. How is this possible? Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Sh.Name <> "Summary" And Sh.Name <> "Trend" And Sh.Name <>...
  2. V

    VBA Event code

    Hi Team, I am working on a worksheet event. My requirement is whenever new data is added to the table I am trying to call a macro. (My table has been connected to Mysql database) Private Sub Worksheet_Change(ByVal Target As Range) Dim Records As Range Set Records = Range("Stockout") If Not...
  3. R

    VBA CHANGE EVENT ARRAY & DICTIONARY

    Dear All Master, Please help the vba code for the vba array event & dictionary because there are 50000 records if I use a formula so it becomes very slow. The code that I made is not perfect sometimes it doesn't work, I want the column header that I marked yellow using the vba event array...
  4. R

    Problem in vba vlookup

    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code so I want a very fast vba code 2. I want to set from column I2 and J2 in the sheet "GSD" and I mark it in yellow 3. I want vba code which is automatic...

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