Control a Macro from Different Worksheet

[steveal]

I have downloaded a worksheet ('Data') which can access Yahoo for stock prices. The macro which runs this is controlled from a button on the worksheet "Download Prices". It works perfectly.
I use this data downloaded from Yahoo on another worksheet ('Mystocks') in the same workbook.

I want to run that macro using a new button on the 'Mystocks' sheet, so that I don't have to keep moving to the 'Data' sheet.
I have tried copying and pasting the button and tried creating a new button on 'Mystocks' without success. I've tried recording a macro to 'push' the button on the 'Data' sheet without success.

Can anyone suggest a solution?

[TMS]

Can anyone suggest a solution?

Not without seeing the workbook and code.

[scottiex]

Cross posted. Norie is already talking to him

https://www.mrexcel.com/forum/excel-...worksheet.html

[steveal]

TMS,

Here is the content of the module. I'm unsure how to post the 'workbook'

Please Login or Register  to view this content.

[scottiex]

put your code in code tags

Please read the forum rules you are breaking quite a lot of them.

also it says

Please Login or Register  to view this content.

but probably you want to name the data sheet if you are trying to run it from a sheet that isn't the data sheet.

[steveal]

Cross posted. Norie is already talking to him

https://www.mrexcel.com/forum/excel-...worksheet.html

Yes. I'm sorry I've cocked things up. I thought I had reached a dead end and Norie was still helping.

[TMS]

I thought I had reached a dead end and Norie was still helping.

Not really the point. If you post on multiple forums or sub-forums, you need to tell people so they have the full picture and don't waste time unnecessarily.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


Please take some time to read the forum rules. Most forums will have their own variations on a theme so it's worth while becoming familiar with them.

https://www.excelforum.com/forum-rul...rum-rules.html

[steveal]

Not really the point. If you post on multiple forums or sub-forums, you need to tell people so they have the full picture and don't waste time unnecessarily.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


Please take some time to read the forum rules. Most forums will have their own variations on a theme so it's worth while becoming familiar with them.

https://www.excelforum.com/forum-rul...rum-rules.html

Sorry, I'm completely out of my depth here.
Please delete the thread.

[TMS]

We're happy to help. In fact, Norie is a senior member here too AND this forum allows you to upload a sample workbook.

So, don't panic. Just take a little time to read each of the points in my last post and we can help you with a solution.

[steveal]

We're happy to help. In fact, Norie is a senior member here too AND this forum allows you to upload a sample workbook.

So, don't panic. Just take a little time to read each of the points in my last post and we can help you with a solution.

TMS,

Thanks for persevering!
I've put the code in tags. I've simplified the workbook and will attempt to attach it.
It consists of just 2 worksheets.
- The Data sheet which does the correct downloading using the form button on the page. To use:
1. Put a new stock ticker at the bottom of the list in column A (use MSFT or AAPL or CSCO or ADT.L etc.).
2. Press the download button and the relevant data will be downloaded.

- The Mystocks worksheet which simply takes some of the downloaded date from the Data worksheet. I've created another form button on the Mystocks sheet.
I want that new button to run the original macro on the Data sheet.

[TMS]

Change your code to the following. You can then assign it to your button on the MyData sheet. It will still run from the Data sheet.

Please Login or Register  to view this content.

You probably need to comment out the following line:

Please Login or Register  to view this content.

[steveal]

TWS,

Perfect!
I did comment out the line you suggested to remain on the Mystocks sheet.

Thanks for the help and the education!
I'll compare your code to the original and try to learn a little more.