Excel workbook project in VS2010

I'm making an excel workbook with code that downloads the entire grand exchange database from the official website. So far, this works pretty good but now I'm stuck on one of the simplest things I can think of, yet can't figure out how to do it.

I want to show a form with a progress bar and accompanied labels, but I can't figure out how to make the form show >_< you'd think that a simple "form1.show()" would do the trick, but it keeps giving me reference errors (Reference to a non-shared member requires an object reference.)... How do I make these object references?

EDIT: I've found it, apparently I had to dim a new instance of my form, then show that... Complicated stuff.


EDIT2:New question, does anyone know how to make a picturebox control (on a worksheet, not on a form) transparent so that it shows the cell color lying underneath it?

I'm stuck with this:

 

As for your form issue, you better set a delimiter or else you could run into some strange issues when multiple instances of your forms are opened.

With the picturebox, setting its "BackColor" property to "Transparent" in the "Web" tab of the color palette should give you what you're looking for. If not, then instead of using a picturebox use a label with its "BackColor" property set to "Transparent", that would definitely work. You'd have to tweak a few other properties however to match what you're looking for (as in image centering, etc.).