| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
InputBox to select cell locations
Hi All
I want to use an InputBox to ask the user for a cell location. Can someone provide me with some code to do this please. This is what I have so far. Basically the last line of the example is where it breaks !! Any input is appreciated Michael Dim x As String, z As Range Application.ScreenUpdating = False userEntry = InputBox("Enter Preferred Cell Location") EndRow = Range("E65536").End(xlUp).Row Set z = Worksheets("Sheet1").Range("userEntry") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| select a cell and the one next to it | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
