View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How to click on a cell and have the content of the cell display in a different cell

Hi,

I have a project to do (similar to a calculator) where I click on cells
containing certain words (or numbers) and when it clicks, the content
of that cell displays in a different cell.

So for example I have 10 cells and in each cell the numbers 1-10. When
I click on the cell containing the number 1, that number appears in
cell A1. When I click on 5, 5 appears in cell A1.

Can someone please help?

Thanks,

Mike