Hi I have following VBA which does not update the sentence B10, B11 and B12 whenever a different club is selected from the drop down menu in cell b2, I have attached the spreadsheet below, please could someone help
Color.xlsm
Hi I have following VBA which does not update the sentence B10, B11 and B12 whenever a different club is selected from the drop down menu in cell b2, I have attached the spreadsheet below, please could someone help
Color.xlsm
Right click on the sheet and select View code. Copy this code over -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The only problem now is sentence always says "increased from" even when it is supposed to be decreased, is there another way
So if it is negative, it should say decreased?
Also i just realised your example sentences in B10:B12 said increased from last year. But C3 says last month. You can change that accordingly in the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks