View Single Post
  #1   Report Post  
Michael
 
Posts: n/a
Default recognize the cell

Hi!

I have a workbook named Ever and a worksheet called Ton, like this:

Row/Column A B C D E F
1 Me 1 Abc 1.2 Etc
Etc
2 You 2 Def 1.4
3 2Me 3 Klm 1.3
4 2You 2 Opp 1.3

1. Im wondering if its possible to write a code in VB that recognize the
cell the user are pointing/clicking at (with the mouse) no matter were in the
worksheet the user is pointing and mark the hole row?

2. If 1. is possible can a inputbox appear, after the user has clicked
(marked) a cell, where both the old value (no mather if it's text or number)
and its address is showing.

3. Is it also possible that the user can change the value/text in the cell
by using the inputbox and after the value/text is changed the user can push a
button on the inputbox called next and the same thing is happening for the
next cell in the next column (the same row).

Did this make any sense?