I have an Input Box which prompts the user for a value. The cell which the value will be assigned to is already formatted for percentages. When i enter a numer int he input box the value that is entered into the cell is 100x greater than the value i typed in. for instance i typed in 33 and the cell displayed 3300%. Now if i don't use the macro and type 33 into the cell it displays 33%. the code is pretty strait forward so i'm not sure why this is doing this.
Dim DesignPercentage As String
DesignPercentage = InputBox("Enter Percentage of Total Cost For Design Charge", "Design Percentage", 0)
If DesignPercentage = "" Then Exit Sub
Range("ak22").Value = DesignPercentage
thanks for taking the time to look over my problem.
nick
Dim DesignPercentage As String
DesignPercentage = InputBox("Enter Percentage of Total Cost For Design Charge", "Design Percentage", 0)
If DesignPercentage = "" Then Exit Sub
Range("ak22").Value = DesignPercentage
thanks for taking the time to look over my problem.
nick