dynamic selection value in textbox!!!

[vini1508]

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

 

[AlphaFrog]

Re: dynamiic selection value in textbox!!!

Checkout this thread

http://www.mrexcel.com/forum/excel-...ns-selectionchange-event-add.html#post3863228

 

[vini1508]

Re: dynamiic selection value in textbox!!!

thank u for ur help...