Control for selecting cells in worksheets
Hi everybody,
I want to find and use a control like that which is used when inserting functions in a worksheet and selecting cells. I will design a userform that is comparable with this used for functions In the first step there is a symbol for the worksheet to click on to make it possible to select a cell (or a range). In next step you confirm the selection by clicking on an other symbol and after that you are back in the userform for the function. Hopefully you will understand what I'm looking for and the question is if I can get that kind of control separate. Thanks in advance for any help. BR Mats -- ESI Update |
Control for selecting cells in worksheets
If I understand you correctly you want the RefEdit control. It is part of the
standard control toolbox for userforms. It will be that last control assuming you have not added any controls to your toolbox... -- HTH... Jim Thomlinson "Mats Nilsson" wrote: Hi everybody, I want to find and use a control like that which is used when inserting functions in a worksheet and selecting cells. I will design a userform that is comparable with this used for functions In the first step there is a symbol for the worksheet to click on to make it possible to select a cell (or a range). In next step you confirm the selection by clicking on an other symbol and after that you are back in the userform for the function. Hopefully you will understand what I'm looking for and the question is if I can get that kind of control separate. Thanks in advance for any help. BR Mats -- ESI Update |
Control for selecting cells in worksheets
Hi Jim,
Thanks for your answer. That´s the control I was looking for. Mats -- ESI Update "Jim Thomlinson" wrote: If I understand you correctly you want the RefEdit control. It is part of the standard control toolbox for userforms. It will be that last control assuming you have not added any controls to your toolbox... -- HTH... Jim Thomlinson "Mats Nilsson" wrote: Hi everybody, I want to find and use a control like that which is used when inserting functions in a worksheet and selecting cells. I will design a userform that is comparable with this used for functions In the first step there is a symbol for the worksheet to click on to make it possible to select a cell (or a range). In next step you confirm the selection by clicking on an other symbol and after that you are back in the userform for the function. Hopefully you will understand what I'm looking for and the question is if I can get that kind of control separate. Thanks in advance for any help. BR Mats -- ESI Update |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com