ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User Interface in VBA (https://www.excelbanter.com/excel-programming/336817-user-interface-vba.html)

krhyme[_6_]

User Interface in VBA
 

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


Tom Ogilvy

User Interface in VBA
 
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" wrote in
message ...

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

User Interface in VBA
 
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[_7_]

User Interface in VBA
 

thanks guys

--
krhym
-----------------------------------------------------------------------
krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39428


krhyme[_8_]

User Interface in VBA
 

I'm going to extrapolate a little more.

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

My problem is the following:

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

2. When passing from one form to the next, there is some kind of jitte
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 uploa
xls files

+-------------------------------------------------------------------
|Filename: rename as xls.txt
|Download: http://www.excelforum.com/attachment.php?postid=3683
+-------------------------------------------------------------------

--
krhym
-----------------------------------------------------------------------
krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39428


krhyme[_9_]

User Interface in VBA
 

http://www.ozgrid.com/forum/attachme...tachmentid=771

--
krhym
-----------------------------------------------------------------------
krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39428



All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com