A worksheet_change to make every cell a formula
$10 CAD
Paid on delivery
Hello I would like to use Excel just like a calculator, and just enter values and formulas without having to enter "=". I would like a workbook with a worksheet I can use just for this.
I got a suggestion below from an online forum as an example of what the code might look like to do the trick, but i am not a programmer myself so can't comment:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
For Each cell In Target
If Left(cell.Formula, 1) <> "=" Then cell.Formula = "=" & cell.Formula
Next cell
End Sub
If there is a different or simpler way, that would work too :)
Project ID: #11415901
About the project
Awarded to:
Hi, I've just completed this for you. Funnily enough I had just finished the code and came back and saw your example which was nearly identical! Your example however doesn't allow you to "delete" or "clear" a More
8 freelancers are bidding on average $13 for this job
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had More
The code you provide, only works in individual sheet, if you want it to work on everysheet contact me
I have many experience with VBA and I ranked 5th in the Excel worldwide competition organized by Certiport and Microsoft in 2015. I have created many userforms and am familiar with re-structure, re-formatting data usi More