multiple "sheets" in a single window

  • Thread starter Thread starter Diomtus
  • Start date Start date
D

Diomtus

Guest
I am building an app that is all alpha-numeric text (no pics/videos/graphics) using Visual Studio 2013. I suppose I could just use excel to accomplish this task, as overall, it is mostly a database – and I did try to use excel, but cell alignment and widths need to be varied in each row and the formulas were ridiculous for complex if_then_ statements, loops, and other functions… My original program was constructed with QuickBasic, which obviously no longer functions on newer windows, so here I am, as a noob to Visual, trying to figure out how to accomplish certain tasks. I am figuring out most tasks on my own, but there is one task that has really got me baffled, and I haven’t had any luck finding tutorials or forum threads that cover this particular task.

Not exactly sure of the best or proper terminology/description of what I am asking help with, so I am going to use an analogy comparative to excel for an example. When one uses excel, there are sheet tabs at the bottom of the window. What I am trying to accomplish is something like this type of structure for my program. Originally, I had about 15 “screens”, each having their own layout, functionality, and displaying their own type of information, but each screen displayed in the same “window” – comparatively, this would be like having 15 sheets in an excel workbook and clicking/jumping about from one sheet tab to another in no particular order – click on a sheet tab and the view in the window changes, it does not populate a new window on the screen, it just changes its view of one sheet to display another. I tried creating multiple forms in visual studio, but this results multiple windows cascading all over my screen, and closing the program meant closing each of all the populated windows first. I passed the thought, in relation to the old quick-basic “clear screen” statement, to use code to remove all contents, labels, buttons, etc in a form and then using code to redesign it, but quickly came to the conclusion of how impractical this would be.

In short, my question is this, how do I construct a program with the sheet-like structure of excel. I am led to understand that with some programming methods in visual basic, there are certain circumstances where the values of “global” (or public) variables are not passed, hence I note that, though each sheet may have its own local variables for sub-routines, functions and calculations, they all still use and change the values of global variables that need to be retained throughout the entire program.

Great thanks to any one who can help me with this.

Blain

Continue reading...
 
Back
Top