Can anyone solve this riddle for me? Why when I change the cell's value in $E$31 on the active sheet does it not continue to work in the "Shop Order" sheet?
I do not have much experience (yet) with VBA so please be gentle.
I really appreciate the wealth of resources that are found on this forum.
Thanks in advance.
Please Login or Register to view this content.
attach a sample file for testing
If solved remember to mark Thread as solved
Here you go:
SampleWorkbook.xlsm
What's your goal ? you did not explain.
Actually I did:
I need help overcoming why this code is not running in the way I am expecting. I am expecting it to continue (as per code) to Shop Order Sheet in order to draw the appropriate amount of boxes, in this sample case - 1 box.Can anyone solve this riddle for me? Why when I change the cell's value in $E$31 on the active sheet does it not continue to work in the "Shop Order" sheet?
Hello SoteriaLive,
When using the With ... End With construct, all members that belong to the object following With must be prefixed with a period.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
ahhh..very good information. Let me try that out. I appreciate the illustration.
I see the problem now. Since I have about 10 times more code than I provided, I realize it will become difficult to do this.
How can I instead call the code from sheet 2 (Shop Order) from within active sheet macro?
Last edited by SoteriaLive; 09-28-2012 at 04:01 PM.
Hello SoteriaLive ,
I am not sure what you want to do differently with the macro.
What I mean, as an alternative, is simply on sheet1 write a basic procedure :
Please Login or Register to view this content.
I hope this helps and thank you again.
Hello ,
Add a new VBA Module to your workbook. Copy and paste the macro code below into it.
The Worksheet_Change event code will then be like this...Please Login or Register to view this content.
Please Login or Register to view this content.
Unfortunately, this does not seem to be doing anything:
The above is in Module 3 and below is behind sheet1:Please Login or Register to view this content.
Please Login or Register to view this content.
You know , I think I just worked it out. It did not seem to like the reference to I46 as it is a calc reference from sheet 1 $E$31. when I pointed it to E31 on sheet 1, it started to work. Standby however, I need to extrapolate this code and make sure I can pull it off for up to 6 carriage boxes.
Thank you for teaching me VBA code.Please Login or Register to view this content.
Hello SoteriaLive ,
It is nice to see you solved the problem. If you have any other questions or issues with the code, let me know. I'll be happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks