Hello All, and thanks for any feedback. This is in Excel 2013
I have the following Macro in my workbook which does exactly what it is suppose to do when I run the macro,
but it does not run on it's own like it suppose to do??? What did I do wrong here?
Thanks for any input
Please Login or Register to view this content.
Last edited by cccote; 03-17-2014 at 07:57 PM.
Declaration is not correct - it must be:
Also code must be in module for correct worksheet.Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Also:
Did you put the code in the Clients worksheet's code module and not in a standard code module like Module1?
Do you want it to run on any change to the worksheet?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi, thanks for the help, I did change it to "Private Sub" (still not working) and it shows in both the worksheet code and
under Module1. See Pictures, and yes I want it to run after any update withing that worksheet. What am I missing?
Module1.JPGSheetModule.jpg
Guys I got it, I thought it was in the worksheet because it showed when selected, but when I double clicked
the worksheet it was empty, so entered it there and Voila it's running.
Thank you both very much for your input, it is appreciated.
As Izandol pointed out, it has to be called exactly this...
And it's only located in the worksheet code module. Not in Module1.Please Login or Register to view this content.
EDIT: disregard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks