ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   recognize the cell (https://www.excelbanter.com/excel-discussion-misc-queries/31685-recognize-cell.html)

Michael

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?



All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com