Hi Aaron,

The code snippet you can use to do such a thing is:

Private Sub CmdOK_Click()

Dim r As Range
On Error Resume Next
Set r = Range(RefEdit1.Value)
If Err.Number < 0 Then
MsgBox "wrong value for range", vbCritical, "Wrong Range"
End If
On Error GoTo 0
End Sub

Once the range is set, it can be used further in the macro.



"Incidental" wrote:

Hi Aaron

You could use the refedit control, it should work for what your
after. To use it you will need to add it to your toolbox you can do
this by right clicking the userform toolbox selecting additional
controls and then finding RefEdit.Ctrl and checking it. Then select
the tool and place it on your userform, it works just like the goal
seek selection method.

Hope this helps

Steve