select range and put range address in variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tombates@city-net.com - 25 Jan 2006 00:25 GMT

Through a command button in a user form, I want to ask a user to select
a group of cells(range). The user selects the cells. I would like to
retrieve the address of that range and place it in a variable.
Mary

Reply to this Message

Jim Thomlinson - 25 Jan 2006 00:42 GMT

Try the RefEdit Control. It should be one of the standard controls in you VBA
toolbox. It is used for selecting ranges...

Signature

HTH...

Jim Thomlinson

> Through a command button in a user form, I want to ask a user to select
> a group of cells(range). The user selects the cells. I would like to
> retrieve the address of that range and place it in a variable.
> Mary

Reply to this Message

N10 - 25 Jan 2006 01:28 GMT

Hi
Also this might help you

sub Example ()

Dim task As Range
Dim str As String

Range("a1:c4").Select ' for example
Set task = Selection
str = task.Address
MsgBox ("TASK= ") & str

End Sub

> Try the RefEdit Control. It should be one of the standard controls in you
> VBA
[quoted text clipped - 4 lines]
>> retrieve the address of that range and place it in a variable.
>> Mary

Reply to this Message