| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an input box to search for a value ...
Robert Bruce wrote:
Roedd <<Steve Tate wedi ysgrifennu: I would like to have a command button on my sheet that when clicked opens up a user input box. The user then enters a numeric value and I would like this value to be found on the worksheet i.e search for the value within column A or range A1 to A65536. If the value is found within the range then I need to activate the cell otherwise if the value is not found then I would like a message box to appear saying the value was not found and then show the input box again. Would Range("A:A").Select Application.Dialogs(xlDialogFormulaFind).Show "", 1, 1, 1, 1, 0 ...work for you? Thanks Rob. That works. -- Rob Keel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| Input one criteria to search in 5 fields | Excel Discussion (Misc queries) | |||
| Search input box | Excel Programming | |||
| Excel VBA- Get user input, search the for match, output to text file | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
