Simple Form Questions

[paul h]

I not trying debug and code, at least not right now. I just want to get familiar with some basics of form behavior in Excel. I have extensive experience on the Access side. Here goes.

1. How do I get my form to pop up on the right side of the screen? I am calling it from the Workbook Open event and it pops up right on top of the chart it controls.
2. When the form is open I have no access to any excel functionality. I can't save, no menus are available, ribbons don't work. What's up with that?
3. There are not many tools in my toolbox. I see no lines or boxes to help organize my form.
4. Is it possible to view the form design and the code at the same time in the VBA window? Having to toggle back and forth is a awkward. It doesn't look like it, but it seems worth asking.

Thanks in advance.

Paul

[scott.s.fower]

I don't know much about numbers 1-3 but the answer to number 4 is yes, you can split the screen
open up the form and double click on it, it will open up the code, then go to window/tile vertically or horizontally

[scott.s.fower]

just found this with a google search, it tells you how to position the form

http://www.cpearson.com/excel/formposition.htm

[paul h]

Thanks Scott. I got the form and the code to tile the way I wanted it to along with the properties window too.

Your 2nd reference didn't work quite the way I'd hoped since it is geared for worksheet ranges and my form is hovering over a chart.

Still, thanks for your time. This may come in handy if I move the chart to a worksheet.

Paul

[paul h]

I did find something else that will work for me. There is a property of the userform called startup position. Of the choices, #3 - Windows Default seems to work the best for me. When I load the form it pops up on the top left corner of my chart which is just fine for my purposes.

[Norie]

Paul

If you set that property to Manual then you can position the form wherever you want.

The code to position the form would go in it's Initialize event.

Please Login or Register  to view this content.

If you want to still be able to interact with Excel display the form modeless.

You can do that in two ways, one set the ShowModal property to False or open the form like this.

Please Login or Register  to view this content.

[paul h]

The ShowModal tip worked great.

I can't get your code to work for the position since my chart is not on a worksheet. I've tried two variants.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Neither one works. I get a runtime error 1004 Application-defined or Object-defined error.