Problem with Active Cell Refence
 

I am just learning Macros & VBA.

I am designing a spreadsheet for picking and booking theatre seats.

Problem:

How do I get the active cell reference to show, of a selected seat,
either in a nominated cell or in a pop up message, but adjusted to
reflect offset seat rows and columns. e.g. The cell reference of Seat
A1 may be D5, seat A2 would be D6 and so on.

I want the actual seat no, not the actual cell reference.

The best I have managed so far is get the actual active cell reference
(which of course isn't the seat no) and then it appears as $A$1.

Hope this makes sense and isn't considered too trivial question.

Many thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Problem with Active Cell Refence
 

If the cell contains the actual see reference then

msgbox ActiveCell.Value

--
Regards,
Tom Ogilvy

"patterson_m" wrote in message
...
I am just learning Macros & VBA.

I am designing a spreadsheet for picking and booking theatre seats.

Problem:

How do I get the active cell reference to show, of a selected seat,
either in a nominated cell or in a pop up message, but adjusted to
reflect offset seat rows and columns. e.g. The cell reference of Seat
A1 may be D5, seat A2 would be D6 and so on.

I want the actual seat no, not the actual cell reference.

The best I have managed so far is get the actual active cell reference
(which of course isn't the seat no) and then it appears as $A$1.

Hope this makes sense and isn't considered too trivial question.

Many thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/