User Interface in VBA

**krhyme** · 08-09-2005, 01:48 PM

I forgot how to program the kind of user interface with a main window with many secondary internal windows... (A mother window with daughter windows that can be opened or closed)

I don't remember how it is called, I used to do it in Visual Basic 6.0

If anyone understands what i'm trying to say... Here are my questions

Is it possible to do that kind of interface in VBA for Excel?
How is it called?

Thanks in advance!!

Tom Ogilvy · 08-09-2005, 03:05 PM

I wouldn't think so since VBA doesn't have VB forms. that said, you might
be able to do it in VB and then have vba call the VB dll.

--
Regards,
Tom Ogilvy

"krhyme" <[email protected]> wrote in
message news:[email protected]...
>
> I forgot how to program the kind of user interface with a main window
> with many secondary internal windows... (A mother window with daughter
> windows that can be opened or closed)
>
>
> I don't remember how it is called, I used to do it in Visual Basic 6.0
>
> If anyone understands what i'm trying to say... Here are my questions
>
> Is it possible to do that kind of interface in VBA for Excel?
> How is it called?
>
>
> Thanks in advance!!
>
>
> --
> krhyme
> ------------------------------------------------------------------------
> krhyme's Profile:
http://www.excelforum.com/member.php...o&userid=25225
> View this thread: http://www.excelforum.com/showthread...hreadid=394288
>

Rafael Guerreiro Osorio · 08-09-2005, 03:05 PM

Hi Krhyme,

Guess you're talking about Multiple-Document Interface, where you have a
main form with child forms. I am not sure whether you can do that with VBA
User forms. Well, at least now you know you're searching for MDI forms...

Best,

Rafael

"krhyme" wrote:

>
> I forgot how to program the kind of user interface with a main window
> with many secondary internal windows... (A mother window with daughter
> windows that can be opened or closed)
>
>
> I don't remember how it is called, I used to do it in Visual Basic 6.0
>
> If anyone understands what i'm trying to say... Here are my questions
>
> Is it possible to do that kind of interface in VBA for Excel?
> How is it called?
>
>
> Thanks in advance!!
>
>
> --
> krhyme
> ------------------------------------------------------------------------
> krhyme's Profile: http://www.excelforum.com/member.php...o&userid=25225
> View this thread: http://www.excelforum.com/showthread...hreadid=394288
>
>

**krhyme** · 08-10-2005, 10:19 AM

thanks guys!

**krhyme** · 08-10-2005, 11:42 AM

I'm going to extrapolate a little more.

I made 2 forms that I try to keep at the same coordinates when they appear and disappear.

My problem is the following:

1. When moving the first form then clicking the button to open the second form. The second form does not keep the coordonates of the first form. But afterwards everything is ok.

2. When passing from one form to the next, there is some kind of jitter for a fraction of a second

Anyone have a better way of doing a similar interface?? Thanks!

(rename the attached file as xls... the forum doesnt allow me to upload xls files)