Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 User Interface Bob P Excel Discussion (Misc queries) 10 February 21st 07 02:11 PM
Creating a user interface in VBA bunmi Excel Programming 1 May 10th 05 12:21 PM
QUI Expert: Excel-based User Interface or OO User Interface? Michael[_27_] Excel Programming 1 November 11th 04 01:53 PM
GUI Expert: Excel-based User Interface or OO User Interface? Michael[_27_] Excel Programming 0 November 11th 04 01:20 PM
User Interface mickeyblake Excel Programming 2 July 15th 03 09:13 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"