Dear Friends,
Is it possible to use "Research Pane" (which pop-up by ALT+click any cell) for displaying any kind of results (like result of array/variables) ?
If yes, could you please give an example or refer to any website which can put me on right track.
Thanks
ali84pk,
The link to your screen shot don't work.
Can you attach an excel file and explain the display you want, versus the cell you select
PCI
- Battle without fear gives no glory - Just try
Dear PCI
Thanks for your reply.
I am trying to re insert the sample picture.
My main objective is, if user press (ALT+any cell), macro should run and collect some results from different sheets, and shows that result in this "Research Pane" rather than in msgbox or in any sheet.
As "Research Pane" is on prime location in workbook and it has quite big area to show results, it would be very helpful for users to view lengthy results as well.
In other words, its all about customization of "Research Pane"
ScreenShot004.jpg
Dear PCI
Thanks for your reply.
I am trying to re insert the sample picture.
My main objective is, if user press (ALT+any cell), macro should run and collect some results from different sheets, and shows that result in this "Research Pane" rather than in msgbox or in any sheet.
As "Research Pane" is on prime location in workbook and it has quite big area to show results, it would be very helpful for users to view lengthy results as well.
In other words, its all about customization of "Research Pane"
ScreenShot004.jpg
Last edited by ali84pk; 09-27-2014 at 01:19 PM.
anyone please help....
It would be much simpler to create a userform set up the way you want your results and then just populate its controls and show it.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks