msgbox to show the result

Hi,

I want to create a macro to show the result when selecting different "Group"

- use input box to input the "group"
- base on the "group", then count the number of completed tasks in "Environment", and number of completed tasks in "Technology"
- Show the result

I've named the columns as Range("Group"), Range("Environment"), Range("Technology")

The input box will be shown as "Select Group",
then when I input "A", how can I use the msg box to show the "Group name" and the 2 results. Example as below:


result.jpg result.jpg

Thanks.