Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |