12 Messages
Digest #3562
Messages
Wed Nov 18, 2015 8:54 am (PST) . Posted by:
bgauer
You can press the F9 (or FN/F9 combo) and your open spreadsheet will re-calculate. I've never bothered to program a CALCULATE button for that reason.
BGauer
Sent from Mail for Windows 10
From: inkt2002@yahoo.com [smf_addin]
Sent: Sunday, November 8, 2015 9:17 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Creating a Calculate Now Button [1 Attachment]
[Attachment(s) from inkt2002@yahoo.com [smf_addin] included below]
Hi Guys!
I know this is not stock market related, but would someone be kind enough to create a Calculate Button in the attached spreadsheet. The formula is in column F. I want to be able to input the 3 variables in the yellow highlighted cells and be able to press CALCULATE to produce the answer.
Very Grateful for any help!
BGauer
Sent from Mail for Windows 10
From: inkt2002@yahoo.com [smf_addin]
Sent: Sunday, November 8, 2015 9:17 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Creating a Calculate Now Button [1 Attachment]
[Attachment(s) from inkt2002@yahoo.com [smf_addin] included below]
Hi Guys!
I know this is not stock market related, but would someone be kind enough to create a Calculate Button in the attached spreadsheet. The formula is in column F. I want to be able to input the 3 variables in the yellow highlighted cells and be able to press CALCULATE to produce the answer.
Very Grateful for any help!
Wed Nov 18, 2015 8:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Won't help, depending on the add-in functions you're using.
That's because web page extractions come from saved copies of the web
pages. F9 or FN/F9 will just cause a recalculation of the formulas with the
same copy of the web page. You need to use the smfForceRecalculation macro
to tell the add-in to purge all of the saved copies of web pages and get
fresh copies from the Internet.
On Wed, Nov 18, 2015 at 9:54 AM, b2bgauer.56@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> You can press the F9 (or FN/F9 combo) and your open spreadsheet will
> re-calculate. I've never bothered to program a CALCULATE button for that
> reason.
>
> BGauer
>
That's because web page extractions come from saved copies of the web
pages. F9 or FN/F9 will just cause a recalculation of the formulas with the
same copy of the web page. You need to use the smfForceRecalculation macro
to tell the add-in to purge all of the saved copies of web pages and get
fresh copies from the Internet.
On Wed, Nov 18, 2015 at 9:54 AM, b2bgauer.56@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> You can press the F9 (or FN/F9 combo) and your open spreadsheet will
> re-calculate. I've never bothered to program a CALCULATE button for that
> reason.
>
> BGauer
>
Wed Nov 18, 2015 9:16 am (PST) . Posted by:
bgauer
Thanks…I need that macro, I see! BGauer
Sent from Mail for Windows 10
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Wednesday, November 18, 2015 10:57 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Creating a Calculate Now Button
Won't help, depending on the add-in functions you're using.
That's because web page extractions come from saved copies of the web pages. F9 or FN/F9 will just cause a recalculation of the formulas with the same copy of the web page. You need to use the smfForceRecalculation macro to tell the add-in to purge all of the saved copies of web pages and get fresh copies from the Internet.
On Wed, Nov 18, 2015 at 9:54 AM, b2bgauer.56@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You can press the F9 (or FN/F9 combo) and your open spreadsheet will re-calculate. I've never bothered to program a CALCULATE button for that reason.
BGauer
Sent from Mail for Windows 10
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Wednesday, November 18, 2015 10:57 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Creating a Calculate Now Button
Won't help, depending on the add-in functions you're using.
That's because web page extractions come from saved copies of the web pages. F9 or FN/F9 will just cause a recalculation of the formulas with the same copy of the web page. You need to use the smfForceRecalculation macro to tell the add-in to purge all of the saved copies of web pages and get fresh copies from the Internet.
On Wed, Nov 18, 2015 at 9:54 AM, b2bgauer.56@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
You can press the F9 (or FN/F9 combo) and your open spreadsheet will re-calculate. I've never bothered to program a CALCULATE button for that reason.
BGauer
Wed Nov 18, 2015 10:37 am (PST) . Posted by:
john_hoel
I cannot find "Links" anywhere in the group. I am looking at this URL: https://groups.yahoo.com/neo/groups/smf_addin/info https://groups.yahoo.com/neo/groups/smf_addin/info
Wed Nov 18, 2015 10:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The macro is in the add-in...
On Wed, Nov 18, 2015 at 11:37 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I cannot find "Links" anywhere in the group. I am looking at this URL:
> https://groups.yahoo.com/neo/groups/smf_addin/info
>
On Wed, Nov 18, 2015 at 11:37 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I cannot find "Links" anywhere in the group. I am looking at this URL:
> https://groups.yahoo.com/neo/groups/smf_addin/info
>
Wed Nov 18, 2015 10:57 am (PST) . Posted by:
john_hoel
I understand that, but how is it activated? How is any macro in the add-in pro-actively activated? I have never unerstood this.
Wed Nov 18, 2015 11:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hit alt-F8 to bring up the macro dialog, type in the name of the macro, and
then click on "Run" when it activates.
I have it assigned to a button on my toolbar, so it's easily available. I
use it a lot.
If you're using the current copy of the add-in, you should also be able to
access it via the context menu (right button click of the mouse). Just go
down to the "SMF" menu and click on the "Recalculate Worksheet".
On Wed, Nov 18, 2015 at 11:57 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I understand that, but how is it activated? How is any macro in the add-in
> pro-actively activated? I have never unerstood this.
>
then click on "Run" when it activates.
I have it assigned to a button on my toolbar, so it's easily available. I
use it a lot.
If you're using the current copy of the add-in, you should also be able to
access it via the context menu (right button click of the mouse). Just go
down to the "SMF" menu and click on the "Recalculate Worksheet".
On Wed, Nov 18, 2015 at 11:57 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I understand that, but how is it activated? How is any macro in the add-in
> pro-actively activated? I have never unerstood this.
>
Wed Nov 18, 2015 11:45 am (PST) . Posted by:
john_hoel
The obvious step (but not to this dunce) was that the macro name can be entered on the macro selection box. I simply did not notice it. Thanks.
Also thanks for the hint about the latest release. I now see the SMF option in the context menu.
Also thanks for the hint about the latest release. I now see the SMF option in the context menu.
Wed Nov 18, 2015 12:17 pm (PST) . Posted by:
john_hoel
The 'Recalculate Selection' function on the SMF context menu is very handy.
Wed Nov 18, 2015 12:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just be aware it's only doing an F9 type recalculate, not a
smfForceRecalculation type recalculate...
On Wed, Nov 18, 2015 at 1:17 PM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The 'Recalculate Selection' function on the SMF context menu is very
> handy.
>
smfForceRecalculation type recalculate...
On Wed, Nov 18, 2015 at 1:17 PM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The 'Recalculate Selection' function on the SMF context menu is very
> handy.
>
Wed Nov 18, 2015 10:09 pm (PST) . Posted by:
truebangalorean
Thank you Randy .. that worked. I did not have the syntax for using OX2 option quote.
Shri
Shri
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar