Hi
use a refedit control for this. This should be in the toolbox then you
create a userform)

"pining" wrote:


Hi! I am new here and would like to ask for your assistance regarding my
problem.

I would like to capture the range address of whatever it is that the
user selects on the active worksheet into a textbox in a modeless
form. The user just have to set the focus in one of the textboxes then
select a range from the worksheet and the range address should be
captured inside the textbox.

The function is similar to that of getting the List Range or Criteria
Range address in the Advanced Filter window of Excel.

Hope you could help me out with this.

Thanks,
Pining


--
pining
------------------------------------------------------------------------
pining's Profile: http://www.excelforum.com/member.php...o&userid=16340
View this thread: http://www.excelforum.com/showthread...hreadid=277294