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
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
