View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AB[_2_] AB[_2_] is offline
external usenet poster
 
Posts: 236
Default Code runs different on different machines

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