My first post! Let's see how it goes :p...
I'm quite new on VBA althought I've been making some things in Excell. I have several columns which show the different prices a product (rows) is sold, but I also want those columns to be able to register values (quantity of units needed).
I've thought of a funtion which checks the other price columns of the row. If the values are 1, 2, 3 etc they should be set back to the price if the selected cell has been changed to 1, 2 or 3...
I'm more used to JavaScript, where there is the OnChange command. Has VBA something like that?
Thank's very much in advance