Luis Diaz
asked on
VBA: Personal Macro Retain/Highlight/Remove values in a selected column
Hello Experts,
I would like to add to my personal macro the following procedure :
Sub Remove_Highlight_Values.
The procedure should do the following.
1-Display a first inbox “Please select the column in which you want to remove/ highlight the reported values". If not action exit sub.
2-Display a second inbox “Enter an specficic value that you want to remove/highlight related to the previous selected column” All the cells in your column which contains the entered will be removed/highIight.
3-Display a third inbox “Do you want to remove the highlighted in yellow values” If yes, remove the values else just keep highlitghted values.
If you have questions, please contact me.
Thank you very much for your help.
I would like to add to my personal macro the following procedure :
Sub Remove_Highlight_Values.
The procedure should do the following.
1-Display a first inbox “Please select the column in which you want to remove/ highlight the reported values". If not action exit sub.
2-Display a second inbox “Enter an specficic value that you want to remove/highlight related to the previous selected column” All the cells in your column which contains the entered will be removed/highIight.
3-Display a third inbox “Do you want to remove the highlighted in yellow values” If yes, remove the values else just keep highlitghted values.
If you have questions, please contact me.
Thank you very much for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works.
Thank you again for your help.
Thank you again for your help.
ASKER
I modified line 10 from:
Open in new window
By
Open in new window
And also I noticed when I click Yes to remove highlithed values I have just a remove of the cell instead of having a remove of the the whole role related to the reported value.
I supposed that the following line should be modify:
Open in new window