A worksheet_change to make every cell a formula

Completed Posted 7 years ago Paid on delivery
Completed 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 :)

Excel Visual Basic

Project ID: #11415901

About the project

8 proposals Remote project Active 7 years ago

Awarded to:

calebedhouse

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

$15 CAD in 0 days
(4 Reviews)
4.7

8 freelancers are bidding on average $13 for this job

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr More

$10 CAD in 1 day
(89 Reviews)
6.0
vlayausa

Hello, I am proficient with Excel and VBA and I can do this for you. Please contact me for more information. P.S. I saw what you added to your project description. Yes, I could explain you how to apply what yo More

$15 CAD in 1 day
(61 Reviews)
4.9
schoudhary1553

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

$14 CAD in 1 day
(42 Reviews)
4.7
haibg2111

The code you provide, only works in individual sheet, if you want it to work on everysheet contact me

$10 CAD in 1 day
(2 Reviews)
0.8
killitmore

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

$10 CAD in 1 day
(0 Reviews)
0.0