View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Merced Edwin Merced is offline
external usenet poster
 
Posts: 10
Default Heres the proble...

OK but afterwards how do I instruct to graph what has been selected with the
Input Box?

"Tom Ogilvy" wrote in message
...
Dim rng as Range
On Error Resume Next
set rng = Application.InputBox("Select a range with your mouse",

type:=8)
On Error goto 0
if not rng is nothing then
rng.Select
else
msgbox "You cancelled"
End if

Note that Application.InputBox is not the same as InputBox alone. The
latter is the vba inputbox and the former the Excel inputbox.

--
Regards,
Tom Ogilvy


"Edwin Merced" wrote in message
...
I need to open an uinput box that should ask the user to type in a

range.
When the user types the range and clicls a button the range shoud appear
selected. How difficult is this??