Excel VBA help on Staff Planner

[180004]

Hi Guys,

I'm very new to this forum so i don't know how they help me. So I have made 3 worksheets for Staff leave planner by using excel VBA. See attached below. I have also added code on visual basic editor to run the program for each employee's duties. For e.g. if you click any of employee's name then pop up will show that he got this much sick leave, public holidays, on duties, etc for whole total sheets. Now I need help on how to run the program if I select particular sheets like sheet1 and sheet2 and then show popup that this is the amount of duties, sick leave, etc. Normally I made program for whole sheets so is it possible to make program for particular i like to choose.

Thanking You

 

[SkipVought]

Hi,

Your link does not work.



Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Check out the Worksheet_SelectionChange event, Target range object.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}