scrolling box/sheet within a sheet..

[harbormaster]

Hello,

I wrote a question about this awhile ago and didn't get a good response, I think it was because I didnt have a very good explanation. I'm going to give it another shot and try to explain more thoroughly.

I have an excel document that I have built somewhat of a user-face, or GUI, into. It has numerous inputs and outputs, and I need to be able to watch this screen at all times while inputting a lot of data. In order to achieve this, I need come up with a way to have a, "sheet within a sheet", or a scroll-able table that I can have on my screen at all times that acts just like another tab or workbook.

To give a better idea of what I need to accomplish I have attached a screenshot of my project. The grey box is the GUI that I need to not scroll/tab away from. The white areas are input areas that are limited to 8-10 lines of input, when I actually need to input up to 200 lines of data for each white area (hence, the reason for a need for a scroll-able table/area)...

I'm hoping I can use VBA to accomplish this, as I have tried a few different options and can't really seem to come up with a good answer. Yes I could rearrange the GUI layout and use the freeze panes tool, but rearranging the layout is not really an option. So if anyone has an idea of where I could start with some VBA it would be really helpful.

Feel free to post any questions, thanks!


Capture.PNG

[mikerickson]

You might open another window, scroll and size that window to where you want.

[Leith Ross]

Hello harbormaster,

This would not be a problem if you had designed your GUI using a VBA UserForm. You could keep the form on top of all other windows and not have the limitations with control and display you have now.

[Solus Rankin]

Can you do MDI parent windows in VBA?

[mehmetcik]

Hi Harbormaster.

Why don't you copy your GUI onto a userform. Either Directly or by mapping to your GUI.

User Show Userform1 vbmodeless

And you can do anything you want in excel and the GUI will still be visible.

Aa Alexander would say........... Simples.

[Leith Ross]

Hello XeRo Solus,

VBA UserForms do not support MDI (Multiple Document Interface) like Visual Basic UserForms. However, with the controls that are available I have never needed to use an MDI.

[harbormaster]

it looks as if adding a listbox to my GUI seems to get my closer to what I am looking for. Is there any way to modify a list box so that it has rows & cells to input values in?

[Leith Ross]

Hello harbormaster,

The ListBox won't but you can use the ListView control.

[harbormaster]

Hello harbormaster,

The ListBox won't but you can use the ListView control.

I was excited after reading your post because, after quickly researching the listview control, it seemed as if I had found my solution. Unfortunately I am using the 64 bit version of office 2010 and it does not support the listview form control.

Any other suggestion?

What about an activeX control? Could I download an activeX Listview control from somewhere? From what I understand activeX controls can be added/utilized, so is there a good source of custom made activeX controls out there somewhere that might help me out?

[Leith Ross]

Hello Harbormaster,

64 bit system, that is a problem. You may be able to embed the worksheet into the UserForm. Not having the 64 bit OS, I really can't say for certain. If you can still do that much the user would see the worksheet as is and be able to interact with it.

[mikerickson]

Functionaly, a multi-column listbox might work.

[harbormaster]

Hello Harbormaster,

You may be able to embed the worksheet into the UserForm.

Could you walk me through how to go about this?

[mehmetcik]

The following is a snippet of code from the attached spreadsheet that is used to display a multi column list box.

Use the userform to locate and display order number 000007.

Please Login or Register  to view this content.