ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Second window open as a sort of dialog (https://www.excelbanter.com/excel-programming/336351-second-window-open-sort-dialog.html)

Claus[_3_]

Second window open as a sort of dialog
 
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



Greg Wilson

Second window open as a sort of dialog
 
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




Claus[_3_]

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







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

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