2 Messages

Digest #3157

smfPricesBetween in Userforn by digsupply

Re: smfPricesBetween in Userforn [1 Attachment] by "Randy Harmelink" rharmelink

Messages

1a

Hi Randy
I can't use the function smfPricesBetween in a Userform, I think the problem has to do with the Format Date, I get a message: "Syntax error". I tried different options but the problem persists. I get the same error with RCHGetYahooQuotes. It doesn't happen with RCHGetElementNumber or RCHGetTableCell-Function, both work OK.
I am using these to show a chart (Charts show button)
I'm attaching the file so you can see the problem
Thank you for your help.
Robert

Attachment(s) from

1 of 1 File(s)

Extras SMF GROUP.xlsm

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: smfPricesBetween in Userforn [1 Attachment]

Thu Aug 21, 2014 9:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I can't do anything with it. It's using objects and reference
libraries I don't have. Also, I've never done anything with forms.

However, I saw these various attempts:

Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, (2013, 1, 1), (2014,
6, 19), "03")
'Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, DATE(2013, 1, 1),
DATE(2014, 6, 19), "03")
'Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, DATEVALUE(2013, 1,
1), DATEVALUE(2014, 6, 19), "03")
'Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, FORMAT((2013, 1,
1),"YYYY,M,D"), FORMAT((2014, 6, 19)"YYYY,M,D"), "03")
'Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, FORMAT(DATE(2013,
1, 1),"YYYY,M,D"), FORMAT(DATE(2014, 6, 19)"YYYY,M,D"), "03")
'Label8 = "Low " & smfPricesBetween(Me.ListBox1.Value, FORMAT(DATE(2013/
1/ 1),"YYYY,M,D"), FORMAT(DATE(2014/ 6/ 19)"YYYY,M,D"), "03")

You don't want DATE() -- which in VBA just returns the current system date,
with no parameters -- you want DATESERIAL(), because you need an EXCEL
serial date for the function. Try that and see if it helps.

On Thu, Aug 21, 2014 at 8:39 AM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy
> I can't use the function smfPricesBetween in a Userform, I think the
> problem has to do with the Format Date, I get a message: "Syntax error". I
> tried different options but the problem persists. I get the same error with
> RCHGetYahooQuotes. It doesn't happen with RCHGetElementNumber or
> RCHGetTableCell-Function, both work OK.
> I am using these to show a chart (Charts show button)
> I'm attaching the file so you can see the problem
> Thank you for your help.
> Robert
>