Excel VBA and Pop Up Windowed Spreadsheet

Joseph Lo

New Member
Joined
Dec 19, 2013
Messages
40
Hi, I know it is near X'mas and all but I am trying to catch up on my Excel project before the new year and would appreciate a little guidance here.

The Excel project that I am building have altogether 50 data tables which get integrated into a master interface. There is no SQL integration here (and I don't want to go that path either). Ok so there is a lot of data lookup in the master interface. All the data are stored in worksheets in the same workbook, so I have worksheets "T1", worksheets "T2", etc.

Say I am pulling this data from worksheet T10 which gives a value of say 2.5....because of the sheer amount of data involved, I want to allow the user to quickly cross-check the source to assure himself that the data I am pulling is accurate (i.e. from the right pool of data).

I have in mind to display the worksheet T10 in a window. I have googled and it appears that many people recommend to go the userform method and to install the spreadsheet control. I would prefer not to do the userform method because it takes longer time for me to code, plus the user may not be able to press tab to scroll through horizontally to see the other data on the worksheet....plus a worksheet interface is a lot more familar to the user and I will also colour code the table to allow easier visual confirmation of the data.

I have gathered I need the

worksheets ("T10").activate

command to work but I couldn't google enough information for me to proceed further.

What I am lacking is:
1. The need to remove the scroll bars on the window spreadsheet that pops up above the main program....ditto to the standard Excel ribbon bars, etc.I have googled and some people suggest that removing standard excel controls is not the best approach as there is no way we can catch excel's events if the spreadsheet crash.
2. The need to only display a certain range from a worksheet. Typically my data worksheet is not very big in size (rows x columns wise).

I am not asking to be spoon-fed. Just asking where are the recommended source of info I can find to allow me to proceed further. I am not very experienced in VBA so appreciate some help here (and patience).

Thanks
Joseph
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Thanks VoG. I googled that one earlier. Couldn't go with it because I need to allow the user to use the keyboard to move between cells on the windowed spreadsheet.....it is a nice solution if I just need to display a static data however.

Any other ideas?
 
Upvote 0

Forum statistics

Threads
1,224,538
Messages
6,179,413
Members
452,912
Latest member
alicemil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top