Getting #Value afte editing Data on userform

**farhadj** · 09-18-2017, 05:07 PM

HI

I have this userform whereby I am capturing information that a has a

1. Unit price
2. Quantity
3. Value

When I edit the data on the userform to update information, the Value Column in the Spreadsheet returns # Value. This happens for all records.
I am not editing the value field at all. The only I will edit the value column is when there is 0 value.
How can I overcome this issue.

Thanks

**xladept** · 09-18-2017, 06:18 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Maudibe** · 09-18-2017, 08:56 PM

farhadj,

Is there a formula associated the the value field on the form (maybe when writing to the sheet)? Are there any characters that populate the value field on the form by default or by code (ex: a space)?

**farhadj** · 09-19-2017, 05:07 PM

Hi Maudibe

Yes there is a formula associated with the field.

**farhadj** · 09-19-2017, 05:10 PM

Hi xladept

I have attached the sheet as requested.

You will notice on the spreadsheet that the second and third items have a value. When I edit the record and update I get a #value error on the value field in the spreadsheet.