ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Evening,
Is there a simple basic code which will change the color of multiple cells from a value entered in search field.
Like this really i suppose.
Type a name in a textbox.
Press the command button.
The code will seach all the cells in column Z1 & down the page looking for the textbox value.
When the code finds a match then each interior cell color is to be changed RED
Thanks
Is there a simple basic code which will change the color of multiple cells from a value entered in search field.
Like this really i suppose.
Type a name in a textbox.
Press the command button.
The code will seach all the cells in column Z1 & down the page looking for the textbox value.
When the code finds a match then each interior cell color is to be changed RED
Thanks