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

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.

On Feb 16, 3:44*pm, Andrew <andrewkgent...@gmail.com> wrote:
> 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

On Feb 16, 9:41*am, AB <austris.bahanovs...@gmail.com> wrote:
> 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.
>
> On Feb 16, 3:44*pm, Andrew <andrewkgent...@gmail.com> wrote:
>
> > 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

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?