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