staffordian wrote:
In case the original screenshot I posted isn't clear - the first dialogue box is hidden behind the second - I've uploaded a second one where I've dragged the second box off to the right to expose the wording of the first one...
Thanks Staffordian, that's a little clearer now as to just what's happening, although I'm still at a loss as to just why it might be the case that it *
is* happening! :O)
I thought the '
z.png' information from your first screen-shot might have been pertinent, and I'm still wondering if it is to be honest. There's nothing in our code that looks at anything called '
z.png' at all, and the Yahoo charts we import into the form web-browser window aren't
.png format either, so this does seem significant somehow.
Just scratching my head here really, but if you open up the Visual Basic Editor (Excel / Tools / Macro / Visual Basic Editor / password = pleaseletmein), can you take a look at the left hand side and double-click on '
UserForm9' for me?
This is what we're used to seeing on the default '
UserForm9' layout -
http://i.imgur.com/kOKP2YP.pngAs you can see, there's some sort of default graphic in there, that looks like a blown-up windows icon, or at least there is on my default version. I'm just wondering if the issue is something to do with that, and was hoping that taking a look at your default '
UserForm9' might show if this is the case. When you open yours up do you see the same
UserForm9 as in my snapshot above, including the blown-up icon in the central WebBrowser area?
If this is the issue, or if we're in the right area anyway, then I'm just wondering if asking the
UserForm9 to navigate to something like the Google homepage before it loads up onto your screen might help solve the issue, so your set-up isn't ever being asked to make the UserForm visible in it's default state, with no navigation having been done yet.
In reality I wouldn't expect you to ever see the Google homepage, as it would instantly be over-written with the relevant chart that you're getting from Yahoo, in the same way that we don't normally '
see' the blown up icon in the default area when the UserForm loads.
To check if this is the issue, can you look in the VBA code for a section of code that says this :-
Code: Select all
If Epic2 <> "" Then UserForm9.Show
If you can find that section of code, and then modify that section so that the above single line is replaced by this small section -
Code: Select all
If Epic2 <> "" Then
UserForm9.WebBrowser1.navigate "http://chart.finance.yahoo.com/z?s=" + Epic2 + ".L&t=1y&q=&l=&z=l&a=v&p=s&lang=en-GB®ion=GB"
UserForm9.Show
End If
Doing that, in theory, asks Excel to point the UserForm9 web-browser area to point towards the default 12-month chart for the relevant share before it's initialised, rather that *on* initialisation. I'm hoping that if, for some bizarre reason, the issue really is with that blown-up icon image on the default web-browser section, then pointing the web-browser to a valid URL before the form in initialised, rather than
during initialisation, might help stop it being an issue for you at all.
Once you've carried out the above code modification, you can go back to Excel and give the single-chart button another go to see if it helps at all.
Not sure at all if this will help, but in the absence of any other ideas, I thought it was worth a shot! :O)
Let me know how you get on?
If you have any difficulties with the Visual Basic side of things then I'm happy to upload a modified version for you to grab and test out.
Cheers,
Itsallaguess