How do I write this so its all on one sheet and still functions the same
Please Login or Register to view this content.
How do I write this so its all on one sheet and still functions the same
Please Login or Register to view this content.
Last edited by dominicb; 09-12-2018 at 10:18 AM. Reason: Code tags added
I may be wrong but I don't think you can write in on one sheet only - because it is triggering different events on different sheets..
Well how would I write to create different events on the same sheet?
God afternoon Braden8898
You combine them both into one module.
They are both triggered by the same event, and you can only have one module, per object, per specific event.
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Im Not sure how to do that? When I open a module and right click to select userform it places it in the same spot as the others. How do I move the Code/UserForms into 1 Module
Hi Braden8898
Please remember that I've never seen the file you are working on, nor do I know what it ultimately will do.
All I've got to go on is what you've posted, which, frankly, isn't much. Something to do with Sheet1 and/or Sheet2 and in your last post you've started mentioning userforms!
You need to describe to me exactly what you've got, what you want and what's happening or not happening.
HTH
DominicB
Ok so this is a screenshot of what D3 does when selected. What I need to have accomplished is the same comment box with different text in several other cells.
Screenshot.png
Last edited by Braden8898; 09-12-2018 at 10:30 AM.
Here is the code on sheet 1. The only way I have been able to make this work is by putting new code on new sheet (Sheet2)
Attachment 589963
Hi Braden8898
So yada and yada1 are userforms? Both of these are set up?
If so, then the post I gave you in post 4 should work.
Remove the Worksheet_Selection module currently in Sheet1 and replace it with the code I gave you.
HTH
DominicB
Edit : According to the image you have posted above, you only have one userform : yada
Your very first post mentions Yada1 - perhaps why it's not working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks