Hi all,
I am trying to get a data set to automatically reorder itself when a value in a cell in a specified column is changed (in the example spreadsheet it would be column C).
This is what I have so far which works when I manually run the sub, but not when I change a value:
What am I doing wrong?
Please Login or Register to view this content.
Many thanks in advance!
Last edited by EllenAW; 03-20-2024 at 06:58 AM.
Hello Ellen,
You've placed your code (a worksheet_change event code) into a standard module. For it to work when you change a value, you need to place it into the worksheet module. But firstly, delete this line:
Sub SortDataWithHeader()
then, to place it into the worksheet module:-
- Right click on the sheet tab.
- Select "View Code" from the menu that appears.
- In the big white code field that then appears, paste your amended code.
Delete the code that you have in the standard module.
I hope that this helps.
Cheerio,
vcoolio.
When wanting to trigger changes in a range on a worksheet, note:
- The code for the Worksheet_Change event must be placed within the worksheet module.
- If the triggering range itself is changed, it means the change event is triggered again. Therefore, you need to turn on/off Application.EnableEvents
Like this:
Please Login or Register to view this content.
Quang PT
Thank you very much to you both for your assistance. This helped greatly!
You're welcome Ellen. I'm glad that we were able to assist and thanks for the rep.
Cheerio,
vcoolio.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks