Automatic Value conversion

D

Dustin

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!
 
J

JE McGimpsey

Dustin said:
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?
 
D

Dustin

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

Tom Ogilvy

How would anyone know?

--
Regards,
Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top