View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Smith[_2_] Kevin Smith[_2_] is offline
external usenet poster
 
Posts: 47
Default Linking a comment to a range

Hi,

I want to try and do a smart thing with cell comments.

The user is asked to create a custom group from a predefined list (for
example say they are a list of names).
The user types in the name of their group (e.g. "Boys") then, using tick
boxes, selects all the boys they want in that group.

What I would like to see is the name of the group appearing on the next
sheet and the cell comment to list those names that were selected.

I can manage the selected data okay, just cannot get that into a comment.

Any help would be great

Cheers

Kevin