I have a spreadsheet in which I would like the user to be able to enter
either a Square foot Dimension or a Square meter dimesion (Whichever one
they have handy) And have excel return the converted value in the "entry
cell" for appropriate dimension type.


For example Column 1 is Labeled Square Meter And Column 2 is labled Square
Feet

If the user enters a value in Column 1, Excel fills the cell in column 2,
with the converted value. This should work in reverse if the user enters a
value in column 2.

Here is some code provided to me by a fellow news groupie.

My question is how do I define the range of appropriate cells? and how do I
run the macro? (I would like it to run automatically, invisible to the user)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If Target = "" Then Exit Sub
Application.EnableEvents = False
If Target.Column = 2 Then Target.Offset(, -1) = Target * 0.0929
If Target.Column = 1 Then Target.Offset(, 1) = Target * 10.76
Application.EnableEvents = True


Thank you for your help!

In article ,
"Dustin" wrote:

My question is how do I define the range of appropriate cells? and how do I
run the macro? (I would like it to run automatically, invisible to the user)

The macro will run automatically if you put it in the worksheet code
module (right-click the worksheet tab and choose View Code). When a
value is entered in column 1 or 2, the calculation takes place and the
result put in column 2 or 1.

The code's already set up to work on the "range of appropriate cells"
specified in your example - it will work if a value is entered in
Columns 1 or 2 (A or B).

What range are you looking for?

You are right, it works just fine!
I just had to change the column numbers 4 and 3 in my case!

"JE McGimpsey" wrote in message
...
In article ,
"Dustin" wrote:

My question is how do I define the range of appropriate cells? and how
do I
run the macro? (I would like it to run automatically, invisible to the
user)

The macro will run automatically if you put it in the worksheet code
module (right-click the worksheet tab and choose View Code). When a
value is entered in column 1 or 2, the calculation takes place and the
result put in column 2 or 1.

The code's already set up to work on the "range of appropriate cells"
specified in your example - it will work if a value is entered in
Columns 1 or 2 (A or B).

What range are you looking for?

How would anyone know?

--
Regards,
Tom Ogilvy

"Dustin" wrote in message
...
You are right, it works just fine!
I just had to change the column numbers 4 and 3 in my case!

"JE McGimpsey" wrote in message
...
In article ,
"Dustin" wrote:

My question is how do I define the range of appropriate cells? and how
do I
run the macro? (I would like it to run automatically, invisible to the
user)

The macro will run automatically if you put it in the worksheet code
module (right-click the worksheet tab and choose View Code). When a
value is entered in column 1 or 2, the calculation takes place and the
result put in column 2 or 1.

The code's already set up to work on the "range of appropriate cells"
specified in your example - it will work if a value is entered in
Columns 1 or 2 (A or B).

What range are you looking for?