Input data to sheet using texbox but with some conditions

[HaroonSid]

Hello, everyone
I am using a combobox and text box to input some data in sheet.

I want if I input data texbox1, then I want to minus the value of sheets("of").range.("C6").Value from textbox1.value before inserting the data to cell

For example
If
sheets("of").range.("C6").Value = 146
And
I input data in textbox1 = 156
Then add value to sheet through is difference of both value
156-146 = 10
Input value should be 10

Thanx

[Winon]

Hi HaroonSid,

Ouch!, Sorry, but I don't follow your example description. LOL.

Please 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.

Thank you.

[HaroonSid]

Thanx a lot for reply guru ji
Sample will upload tomorrow because I am no using mobile,
I will explain u one more time, what I want

For example
I input data in texbox1 = 156
And
Range
sheets("of").range.("C6").Value = 146
Then before sending data to cell using text box I just want less
sheets("of").range.("C6").Value from textbox's value

156-146= 10

[HaroonSid]

here is sample worbook