Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Alright, I have code that will have the user insert a Contract # into a
specific cell. This works fine. But what I would like to know, is it possible to have the inputbox message to already have the Cells Value Listed, then the user would insert the new information only if neccessary. For Example: Cell A1 would have the contract # "123" already listed. The inputbox would ask the user "Please Enter Contract # or if this is the Correct # then press OK". But in the area where the user enters the information, the "123" would already be listed. Can this be done with a Inputbox? I hope this makes sense. Any help is appreciated. Here is the code that I have. Dim ans As Variant ans = InputBox("Please Enter Contract # or if this is the Correct # then press OK") With Worksheets("Agreement") Cells(8, 12) = (ans) End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |