| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Q
Thanks Roger, I've tried to format the output cell as 0.00%, but it
only shows as 0.00, why is that? uservalue = InputBox("Value to use? Between 0% and 99%") uservalue2 = Format(uservalue, "#.00") If uservalue2 < 0 Or uservalue2 99 Then MsgBox "Value outside range of 0% to 99%" Exit Sub End If If uservalue2 1 Then uservalue = Format(uservalue2 / 100, "#%") Else uservalue = Format(uservalue2, "#.00%") End If Range("B3").Value = uservalue Selection.NumberFormat = "0.00%" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| =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 | |||
Threaded Mode
