| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign a function to a Command Button
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assign a function to a Command Button
Check your other post.
MUEEN SEHDI wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assign a function to a Command Button
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 "Dave Peterson" wrote: Check your other post. MUEEN SEHDI wrote: 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. -- Dave Peterson . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assign a function to a Command Button
Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html John Walkenbach's books are very good to start. See if you can find them in your local bookstore/internet site and you can choose what one you like best. MUEEN SEHDI wrote: 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 "Dave Peterson" wrote: Check your other post. MUEEN SEHDI wrote: 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. -- Dave Peterson . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign Function to a Command Button | Excel Discussion (Misc queries) | |||
| Assign a macro to a command button | Excel Discussion (Misc queries) | |||
| Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
| How to assign a marco to a command button | Excel Worksheet Functions | |||
| How do I assign a macro I have created to a Command Button in Exc. | Excel Discussion (Misc queries) | |||
![MUEEN SEHDI[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
