Thanks



-----Original Message-----
You will need to create a userform and place a label on
that form. Then run
the test funtion which should be placed in one of the
sheets...

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
UserForm1.Label1.Caption = Target.Address
End Sub

Sub test()
UserForm1.Show False
End Sub


"Todd Huttenstine" wrote:

Hey

I would like to be able to have a little popup
dialogbox
that allows me to click in Excel and select a range of
cells by clicking the mouse on a cell and dragging into
the cells I want to include into my range. Then after
I
release my mouse button, the actual range pops up in
the
dialogbox. For example I click a button and the dialog
pop up. I click in Excel and drag from A3 to B20.
When I
release the mouse button, I would like for the popupbox
textbox to show A3:B20. (This type of thing can be
observed when creating a chart or pivot table.)


How do I do this?


Thanks
Todd Huttenstine

.