Hi All

I have a system which tracks training courses and jobs for staff.

All the training courses are laid out in columns on one worksheet. The
jobs are columns on another sheet and the rows on both sheets are the
staff.

When a user adds a new job I need to know which course provides the
training to do that job. Therefore I need a nice way to ask the user
which column on the course sheet is for the right course as I link the
course with the job on the job sheet.

I could use a data validation with a list referring to a dynamic range
name based on the course headers but this is proving difficult due to
the formatting of the course headers which I cannot change.

Is it possible to use a control or something to get the functionality
of a "cell selector" like Excel provides when your are selecting a
cell or range in, say, Conditional Formatting?

Then I could read the cell that the user selects and deduce the
correct training course column.

Is such a control available?

Chrisso