want to get selected region address in textbox
i have a userform.. when a form loads i want to select the range from active sheet and after i select a range i want to display the selected cell address in textbox.. i want to do this automatically without using inputbox or clicking any button... i want to select the range and its address should be displayed in textbox... plss help
also it is an addin which i'm creating so i guess i wont be able to use Worksheet_SelectionChange Event
Last edited by vini1508; 02-17-2016 at 06:53 AM.
Hi vini1508,
Try the following code which is included in the attached file. Remove the code from the 'Sheet1' module if you don't want to be able to change the range after the UserForm is displayed. To be able to change the range after the UserForm is displayed you need a 'Modeless' UserForm which DOES NOT lock out Excel.
In the Sheet1 code module:
In the UserForm1 Code Module:
Please Login or Register to view this content.
In Ordinary code module ModUserForm1:Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
Thanks LJMetzger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks