mhenk
Well-known Member
- Joined
- Jun 13, 2005
- Messages
- 591
Okay, that's not entire true. This code works when I step through it, but not when I run it with F5... is it moving too fast?
the 2nd if statement is the one that's not working for me. It will change based on the msgbox input when i step through it, but not when I run it. Come to think of it, it might not always work when i step through it either... I'll have to check.
Do I need to put a break/pause in there somehow?
Code:
If CheckSolver Then
a = MsgBox("Solver installed! Do you wish to utilize advanced functionality?" & Chr(10) & "(Choosing Yes will load solver, No will load goalseek)", vbYesNo, "Choose your Optimization Method")
If a = 6 Then Sheets("Lookup Values & Tables").Range("SolSeek") = "Solver"
End If
the 2nd if statement is the one that's not working for me. It will change based on the msgbox input when i step through it, but not when I run it. Come to think of it, it might not always work when i step through it either... I'll have to check.
Do I need to put a break/pause in there somehow?