I would like to execute a macro i have when a cell changes , preferably this would be only if another cell was above zero
so if cell B21 was above zero and changes were made to either Cell F3 or F4 then my macro CSVcreate would execute (This isnt the only time this macro will run though i also have it assigned to form buttons to run when needed)
any help would be appreciated, thanks
You can use the Worksheet_Change event for this. Bring up the Sheet's Code page by double clicking the sheet in the Project Explorer (Usually on the left side of the VBE). Then click the left combobox above the Code section and change it to Worksheet. Then click the right combobox and change it to Change. Then paste the following so your code looks like this:
Please Login or Register to view this content.
That should do it!
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
fantastic , works a treat !! many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks