Hi all,
I am a new but keen convert to the wonderful world of VBA, and am hoping that some kind and knowledgeable person might be able to give me a quick bit of help.
To help with the timetabling of staff and volunteers for a children's after school club I need to create a macro which will function as follows:
- Before the macro is read I will manually select a chunk of text
- I run the macro. An Input box appears. I type someone's name into it and hit OK.
- The Macro searches within the highlighted selection and formats each occurence of the inputted name (red and strikethrough)
This will provide a quick way of fool-proofing and speeding up a task which I currently have to do manually very often, namely seeing who is off on a certain day and making sure they are marked as such on the timetable so that I can see what gaps need to be filled.
Huge gratitude for anyone who can point me in the right direction.
Many Thanks,
Alan