Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code:
vAmount = ActiveCell.Value Dim EnterAmount As Variant EnterAmount = InputBox("Enter the amount to Hardcode: ", , vAmount) If EnterAmount < "" Then ActiveCell.Value = EnterAmount End If Now if I hit cancel the amount will remain what it was. But if I use Application.InputBox: EnterAmount = Application.InputBox("Enter the amount to Hardcode: ", , vAmount, , , , , Type:=1) then if I hit Cancel I will get a False in the cell. How do I make it so if I hit Cancel with using the Application.Input box the cell will not change to False but will remain what the cell was when I entered the cell like the InputBox does. Thank you for your help, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
application.inputbox | Excel Programming | |||
Inputbox and Application.InputBox | Excel Programming | |||
inputbox and application.run macro1 | Excel Programming | |||
application.inputbox | Excel Programming | |||
Application.Inputbox Question | Excel Programming |