Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding more sort fields to the SORT Dialog Box | Excel Discussion (Misc queries) | |||
Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
How to resize Data Form dialog window? | Excel Worksheet Functions | |||
control of dialog macro dialog box. on open | Excel Programming |