Assign a function to a Command Button

  • Thread starter Thread starter MUEEN SEHDI
  • Start date Start date
M

MUEEN SEHDI

How can I assign a function to a command button placed in Excel 2007 Worksheet?

I need to use Goal Seek command (from Excel Menu/Data/What-If Analysis/Goal
Seek) in my worksheet to do some calculation. However instead of following
the
menu path, I want to place a button in my worksheet and assign the Goal seek
command to this button. By clicking on this button, the dialogue for Goal
Seek function should appear.
 
Check your other post.

MUEEN said:
How can I assign a function to a command button placed in Excel 2007 Worksheet?

I need to use Goal Seek command (from Excel Menu/Data/What-If Analysis/Goal
Seek) in my worksheet to do some calculation. However instead of following
the
menu path, I want to place a button in my worksheet and assign the Goal seek
command to this button. By clicking on this button, the dialogue for Goal
Seek function should appear.
 
Thanks Dave. I am grateful for your support. It worked well. May I seek you
refer me some guide for some VB related stuff for handling such scenarios.

Regards,
Mueen
 
Back
Top