Code runs different on different machines

A

Andrew

Hello,
I have a long excel program which runs fine (and has been running fine
for about a year) on all machines except one. One this one machine I
get some odd behavior. It is as follows:

A user form is used to enter values into cells in one of the
worksheets. There are 5 values, two strings, two currency values, and
1 number. On this one particular machine, the values enter into the
sheet in a repeated form, as if they were part of an array. So, the
userform input number 105.00 would show up on the worksheet as 105.00
105.00 105.00 105.00 105.00 105.00 105.00.

As I said, this code has been running fine on three other machines for
about a year. The only problem I've had is on this one machine. All
machines are using Excel 2007.

Does anyone know if there is a setting in the excel options area which
could affect how the macro runs? Or any other reason why a macro
would run on one machine and not another?

thanks,
Andy
 
A

AB

Not that i'm aware of (in the scenario you describe anyway).
Try stepping through the code (F8) and see what causes it to do so.
 
A

Andrew

Not that i'm aware of (in the scenario you describe anyway).
Try stepping through the code (F8) and see what causes it to do so.

I've done the F8 walk through, the error occurs when the command to
write to the cell is made. But I don't see why there would be an
error. But here's some new and odd information: We went into Excel
Options >> Advanced >> Lotus Compatibility and selected the box for
Transition Navigation keys. The only reason we did this was because
the other machines had that setting selected. After doing that, the
code worked. ??? I wrote the code myself, and there are no lotus
commands in it. The whole thing was done on Excel 2007. Can someone
explain how that setting could have made a difference?
 

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