Forum Discussion
Excel Data entry
Hi Everyone,
It would be awesome if someone can help me with this.
So, Here's the situation:
I want to enter a value: either -1 or +1 in cell B1. But I want B1 to show/return (-1*A1) or (+1*A1).
Any help is appreciated.
Thanks!
Thanks for sharing the file. Here is your file with the code in it. Let me know if this works as desired.
10 Replies
Please test the attached by entering either 1 or -1 in cell B1. The solution is based on Change_Event and the following code is placed on Sheet1 Module.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.CountLarge > 1 Then Exit Sub On Error GoTo Skip If Target.Address(0, 0) = "B1" Then Application.EnableEvents = False If Target = 1 Or Target = -1 Then Target = Target.Value * Range("A1").Value End If End If Skip: Application.EnableEvents = True End SubSubodh_Tiwari_sktneer Thank you so much! It worked!
Now If I want to do that for a whole table? Say 22 Columns and 10 lines?
Wouldn't it be better that you upload a sample file to show the layout of your data as the solution is based on VBA and if you change the layout, it won't work correctly? After uploading the sample file, describe your requirement again based on existing data in the file and let me know what do you want to achieve with the help of cell references.
