Excel VBA: Trigger macro on cut/paste/delete/insert events -


i have conditional formatting rule defined macro, deletes old rules , replaces them updates ones:

sub setcondformat()     set table = activesheet.listobjects("rules")     table.range.formatconditions.delete     set attribute = table.listcolumns("attribute")     attribute.databodyrange.formatconditions _     .add(xlexpression, xlequal, "=isempty(a2)")         .interior             .colorindex = 0         end     end end sub

the conditional formatting in excel needs updated. otherwise cell ranges in rules fragmented.

let's have 2 rules:

  1. make $a$1:$a$30 red
  2. make $b$1:$b$30 blue select a10:b10 , copy/paste a20:b20.
    excel delete conditional formatting.

for a20:b20 rules applied cells , add new rules have formatting a20:b20. end 4 rules:

  1. make =$a$20 red
  2. make =$b$20 blue
  3. make =$a$1:$a$19,$a$21:$a$30 red
  4. make =$b$1:$b$19,$b$21:$b$30 blue

this happens, when table structure gets changed through cut/paste/delete/insert events.

how trigger above vba macro on cut/paste/delete/insert events?

you use shortcut macro

vba event trigger on copy?

if don't want go way you'll need use windows api:

is there event fires when keys pressed when editing cell?


Comments

Post a Comment

Popular posts from this blog

go - serving up pdfs using golang -

Image
just wondering if guys can code. it works serving images not pdf brochure. in advance func main(){ http.handlefunc("/", func(w http.responsewriter, r *http.request){ filename := "/var/www/filedipenser/brochure.pdf" streampdfbytes, err := ioutil.readfile( filename ) if err != nil { fmt.println(err) os.exit(1) } b := bytes.newbuffer(streampdfbytes) w.header().set("content-type", "application/pdf") if _, err := b.writeto(w); err != nil { fmt.fprintf(w, "%s", err) } w.write([]byte("pdf generated")) }) err := http.listenandserve(":4111", nil) if err != nil { log.fatal("listenandserve: ", err) fmt.println(err) } } the code bit inefficient appears working. however, pdf viewers might sensitive extraneous output adding end of http response stream...
Read more

python - Best design pattern for collection of objects -

i have following architecture: +-----------------+ | collection | | | | | | | | | +-----------------+ | ^ | | create() | | | | v | getitem(b) +------------+ | | item | | | | | | +------+ | | +------------+ a class managing collection of items, creates items. , these items may need other items collection. the actual code in python, , collection passes parameter created item . see it, bad practice. improvement can see pass few functions of collection needed item , instead of whole instance. for example: class collection: getitem(self, id): ... createitem(self, id): item = item(id, self) # <-- pass self ... class item: __init__(self, id, col): ... col.getite...
Read more

how to add preprocess loader in webpack 2 -

i trying add preprocess loader in webpack 3. have installed successfully. not working here's webconfing file var debug = process.env.node_env !== "production"; var webpack = require('webpack'); var path = require('path'); module.exports = { context: path.join(__dirname, "src"), devtool: debug ? "inline-sourcemap" : null, entry: "./js/app.js", module: { loaders: [ { test: /\.jsx?$/, exclude: /(node_modules|bower_components)/, loader: 'babel-loader!preprocess-loader?+debug', // query: { // presets: ['react', 'es2015'], // plugins: ['react-html-attrs', 'transform-class-properties', 'transform-decorators-legacy'], // } }, { test: /\.css$/, loader: "style-loader!css-loader!sass-loader" } ] }, output: { path: __dirname + "/src/", f...
Read more