Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Heres the proble...
Edwin,
Try something like the following: Dim Rng As Range On Error Resume Next Set Rng = Application.InputBox(prompt:="Select a range", Type:=8) On Error GoTo 0 If Not Rng Is Nothing Then Rng.Select End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Heres my macro code... | New Users to Excel | |||
Proble with using match function | Excel Worksheet Functions | |||
Heres the proble... | Excel Programming | |||
Heres the proble... | Excel Programming | |||
heres one for ya.. | Excel Programming |