Sir Babydum GBE
07-07-2005, 01:02 PM
Hi
I'm hoping to be able to have an automatic text box - with fairly large fonts - that will return the contents of, say, B1 on sheet2 when I click on B1 on sheet1, and the other way round. Whatever cell I click on the one sheet, it should display the value of the same cell on the other sheet. This may involve merged cells too.
Also, can this code copy any merging/demerging or formatting that I do on the one sheet straight onto the other sheet simultaneously.
Can this be done please?
Thanks in advance.
I'm hoping to be able to have an automatic text box - with fairly large fonts - that will return the contents of, say, B1 on sheet2 when I click on B1 on sheet1, and the other way round. Whatever cell I click on the one sheet, it should display the value of the same cell on the other sheet. This may involve merged cells too.
Also, can this code copy any merging/demerging or formatting that I do on the one sheet straight onto the other sheet simultaneously.
Can this be done please?
Thanks in advance.