VBA to Find and Format Text string defined using Inputbox within selection

[sistemalan]

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:

1. Before the macro is read I will manually select a chunk of text
2. I run the macro. An Input box appears. I type someone's name into it and hit OK.
3. 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