#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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"