Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    bring up goal seek (excell 2003)

    I am wondering if someone could tell me how I can bring up Goal seek by using a macro?

    I want to have a button on my worksheet that brings it up?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: bring up goal seek (excell 2003)

    To perform a goalseek without intervention by the user, use the GoalSeek method of the Range object. Type GoalSeek in the Visual Basic Editor and press F1 for info and an example.

    To display the GoalSeek dialog from code:

    Application.Dialogs(xlDialogGoalSeek).Show

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bring up goal seek (excell 2003)

    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •