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