flightjock
New Member
- Joined
- Mar 18, 2002
- Messages
- 48
I have a workbook consisting of 12 sheets. On every sheet there are some statistics in certain cells, always in the same range (say column BE) but out of sight due to the size of the sheets. I would like to have a userform that shows these statistics by clicking a macrobutton. Each workbook sheet would get such a macro button and the userform should show the statistics of the particular sheet where the button was pressed. I know how to make a new userform but I can't figure out how to link the controls to the active worksheet. Any help would be appreciated.
Thanks,
Anthony
Thanks,
Anthony