View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emlou85 via OfficeKB.com
 
Posts: n/a
Default A formula for displaying the cell reference of the selected cell

I have drawn a keyboard in excel (B1 is note C, C2 is note D etc). The user
is told to click on the note
E. I then have an If statement that says if cell A2 displays D1 (ie note E)
then to say 'well done that is correct' and if not then display 'wrong have
another go'. My problem is getting a formula in A2 which displays what has
been selected, so the If statement can work!

Emma

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1