Kamis, 19 November 2015

[smf_addin] Digest Number 3562

12 Messages

Digest #3562
1b
Re: Creating a Calculate Now Button by "Randy Harmelink" rharmelink
2b
2d
2g

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!

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
>

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

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
>

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.
>

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.

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.
>

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
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar