Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tab245

    Display UserForm on TaskBar?

    hm... the UserForms are coming from VBA code that I created... VB program calls "main" macro in Excel. This macro, in turn, calls several other subrutines and displays three UserForms, which shows what task is performed ("constracting graph..", etc). Yes, maybe, instead...
  2. tab245

    Display UserForm on TaskBar?

    Yes, this would be good... Unfortunately, I am using Excel Solver in my optimization problem. It is free as opposed to VB Solvers, that cost a lot... Thank you anyway!
  3. tab245

    Display UserForm on TaskBar?

    Hi, Rob, I am calling Excel macro from VB program. Excel is minimized all the time (by some reason it is even not displayed on the task bar...). So, I have the VB window, and above it I have a UserForm generated by Excel. However, if I switch to any other application (e.g., internet), I can...
  4. tab245

    Display UserForm on TaskBar?

    Hi! Is there any way to display Excel VBA UserForm on the TaskBar? Thank you! Tab
  5. tab245

    Solver

    Hi, RobBroekhuis, Zathras and Domylee, Thank you for replying! I tried to record the macro as you suggested ("Macro" - "Record Macro"). It works fine! Moreover, after this small test works fine - my other program stops giving the error! I tried my program on Excel 2002...
  6. tab245

    Solver

    Hi, domylee, Did you find a way to solve the problem? I am getting a similar error in my macro. I would appreciate if you advice me how to solve the problem. Thank you in advance!
  7. tab245

    Excell: macro to handle Solver errors

    O'k! I just got the answer: I should check the value of SolverSolve. I can use something like this: If SolverSolve <> 0 Then Stop Thank's anyhow! Tanya
  8. tab245

    Excell: macro to handle Solver errors

    Hi! I am fairly new to VBA, and I would appreciate any advice. I have recorded a macto to run SOLVER. However, I do not know how to read SOLVER results automatically. I mean, how to check if SOLVER solution converges or not. I added the lines that takes solver control from the user...
  9. tab245

    Excel, Macro, References

    Yaha!!! this works! Thank you! the only problem is that I can not add a reference and execute a function from the reference in the same sub. But this is fine - I can put them into different macros and run sequentially. Here is what I have: ---- add the reference on SOLVER Sub ss3()...
  10. tab245

    Excel, Macro, References

    Hi! I am looking for a code that would automatically include reference to an Excel macro. Currently, I need to go to Tools-References in VBA to include a reference. But, maybe, there is a way to code this? Thanks!
  11. tab245

    SOLVER VBA Reference

    Hi! I am looking for a code that would automatically include reference on SOLVER in VBA. Can anyone help? Thank you!
  12. tab245

    Using a macro to automate solver

    Hi! Is there any way to automate this process? I mean, to write a code that would include the reference automatically? Thank you!
  13. tab245

    Advice Required Using Solver from within VBA

    Hi! I am not a big expert, but I think, this should work: ' Do not display the Solver Results dialog box. SolverSolve UserFinish:=True ' Finish and keep the final results. SolverFinish KeepFinal:=1 Tanya

Part and Inventory Search

Back
Top