LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Second window open as a sort of dialog

Hi Greg

Thanks for your clue, but i dont want to use Dialogs because of the amount
of often very different content.
It is a lot easier for me on a sheet, because there is a lot of calculations
in differetn formulas.

Regards

Claus



"Greg Wilson" skrev i en meddelelse
...
Ignore this if it you are already familiar with TabStrip controls or this
is
impractical for your situation. Suggested is that you revert to the
"dialog"
(user form) approach and use a TabStrip control.

If you are not familiar, when you click the different tabs in a TabStrip
control, instead of taking you to another page (parent object for more
controls) like in a MultiPage, nothing really happens except that the
value
property of the control changes (i.e. it only simulates changing pages).
Therefore, you don't have to have a whole new set of controls for each
page.
Instead, the intent is that your code just changes the contents or state
of
the same controls. If necessary, you can also change visible status and
move
controls. Of course, assumed is that essentially only contents need
change.

I use a TabStrip for one of my projects so the user can enter a series of
list values into a a number of columns of text boxes. The number of text
boxes required would be 5 fold higher if I used a MultiPage (270 instead
of
54).

Regards,
Greg

"Claus" wrote:

Hi

I'm doing a calculation-program for the building industry.

In the program i need to open a second window as a sort of dialog box in
order to enable the user to modify a "Model" (An entire roofing or the
outer
walls in a building).

I could do a real dialog for each Model, but ending up with approx. 50
Models (each one different), it seems like a lot of work.

Question: Can i open a second window:2 (for the model), resize it
while
window:1 is maximized, and make sure that the user only can exit through
a
button. ?


I've searched the site for topics like this without succes

Hoping for some guidance


Claus Persson





 
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
Adding more sort fields to the SORT Dialog Box Doug V. Excel Discussion (Misc queries) 3 October 6th 08 07:30 PM
Retaining Sort order in the Sort Dialog box CBittinger Excel Discussion (Misc queries) 2 January 9th 08 05:01 PM
Excel Open Dialog Improper Sort [email protected] Excel Discussion (Misc queries) 4 May 17th 06 02:40 PM
How to resize Data Form dialog window? Compucat Excel Worksheet Functions 1 June 8th 05 11:24 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM


All times are GMT +1. The time now is 12:29 AM.

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"