| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User input into Macros in Excel 2000
Hi I am trying to add a "replace" function to a macro so that a part of an equation in a worksheet can be changed. The syntax being used is Cells.Replace What:="200907", Replacement:="200906", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False but I want the user to be able to change the 'What' and 'Replacement' values via a dialogue box. Can anyone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 User Forms & Macros - Will they work with Excel 2007 | Excel Programming | |||
| input 7 in a cell in EXCEL 2000, it will automatically change to 8 | Excel Discussion (Misc queries) | |||
| Excel Paste w/ No User Input | Excel Programming | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
