LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default Strange macro behavior - result is correct every other time

Hello,
I am stumped. I have a large VBA program with about 8 subroutines and
maybe 50-70 variables. The program itself is too complicated to
explain, however as a gross approximation, it works about like this:

Private Sub Main_Clicl()
for x = 1 to 1000
if x^2+10x+25 = 100 then
exit sub
next
cells(1,1)=x
End Sub

So, the program would search for an answer. Anyway, let's just say
that for this example, when I click on a button on the screen, I get
an answer in cells(1,1). So, I click it one time and I get the
correct answer; I click a second time and I get an incorrect answer.
I click again, and I get the right answer. And this pattern
continues.

I am not using any static variables. All my variables are global.
Can someone please explain what might be happening.

thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange behavior with old macro now throws error with "Application owlnevada Excel Programming 2 March 31st 09 06:19 PM
Sum Time - strange result (site & cpearson researched) proverbs Excel Worksheet Functions 4 May 14th 07 12:19 PM
Excel 2007 (Beta) - strange behavior of macro AndrĂ¡s Excel Programming 6 November 10th 06 06:08 PM
Strange Personal Macro Workbook Behavior stretch Excel Discussion (Misc queries) 4 August 4th 05 07:39 PM
Strange macro behavior! davegb Excel Programming 9 May 20th 05 10:50 PM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"