Hi Dave

Thanks for the response.
Ok I will have 5 states for each cell.
These will be:
F, P, S, E or <blank

Depending on the state I need a comment added to the cell and the data for
that comment to come from cell A1 for F, A2 for P, A3 for S, A4 for E and if
<blank no comment to be added.

If only I could do exactly what you suggested with vlookups or even just a
link to the other sheet would be fantastic, however I need to keep the state
in my cell so a comment box is the best way.

I know I can use: =getvalueandcomment(a1) statement in the actual cell to
pull in the data and comment from the corresponding cells in the other
worksheets, however - how do i get this to work in a macro that would allow
me to choose which value and comment to pull across depending on the cell
state?

Is this possible or am i trying to do something that is beyond excel?

Mike

"Dave Peterson" wrote:

First, I am confused about what you want.

If cell A1 is different from F, then what happens? What are the rules?

But you may find that your life in excel will be much easier if you keep your
data that you want in cells--not comments. You'll be able to use the builtin
functions (like =vlookup()) to retrieve those values.

Mike wrote:

Help!!!

I am trying to change the data within my comment boxes dependant on the cell
value and if the source changes.

In my workbook I have 4 worksheets

Sheets 1 - 3 are my data sheets where the values can change

Sheet 4 is my working sheet where I want comment boxes added to each cell
dependant on the cell value. Ie if Cell A1 = F then a comment box should be
added which takes the comment from Worksheet 1 cell A1. etc etc etc
However I also need any updates on my data sheets to be shown in the
comments boxes on worksheet 4.

Any ideas please .... ???

I hope that makes sense, if not please say and I will try to clarify it better

Thanks in advance

Mike

--

Dave Peterson