Apply formula Calculation by VBA Value ="to Forumula"

[DocAElstein]

…u r a Proffessional Programmer …

No , this wrong
I am a Builder. I build houses. I build now my castle in Germany
मी एक बिल्डर आहे. मी घरे बांधतो. मी आता जर्मनी मध्ये माझा किल्ला तयार करतो
I only do Excel for fun or for my private use
मी फक्त गंमत म्हणून किंवा माझ्या खाजगी वापरासाठी Excel करतो

I prefer older computers
I buy an old lap top. ( Operating system XP or Vista )
I buy an old large television.

I use Excel 2003 , 2007 or 2010. ( Microsoft Office 2003, 2007 or 2010)

I connect television to Lap top with HDMI cable ( or VGA cable )

Use two monitors /Extended desktop
XP: https://www.wikihow.com/Use-Extended...-in-Windows-XP
https://www.youtube.com/watch?v=cr8T...ature=youtu.be
Vista : https://www.instructables.com/id/How...crosoft-Vista/
http://www.excelfox.com/forum/showth...ll=1#post11167
https://www.youtube.com/watch?v=bfo3UyaS_j8
http://www.excelfox.com/forum/showth...ll=1#post11167



Then … Open Excel,
Alt + F11

Now you have Spreadsheet in high resolution on television, and VB Editor on lap top screen

This is me at home now:
Lap top is on table. 20190916_LapTop on Table.jpg : https://imgur.com/d4Bc5ZX
20190916_LapTop on Table.jpg

Television is hanging on the house wall 20190916_Television on Wall.jpg : https://imgur.com/FSSTVb6
20190916_Television on Wall.jpg

Now you have Spreadsheet in high resolution on television, and VB Editor on lap top screen:
20190916_HDMI cable.jpg : https://imgur.com/aFWGKan
20190916_HDMI cable.jpg

---

Doc Sir i am looking to buy a lap top ….. let us assume the code is best …..

My opinion.is

If you have best code, then old cheap computer, + old cheap Television for extended second Monitor. Use XP or Vista Operating system. Use Excel 2003, or Excel 2007 or Excel 2010
If you have best code then this is OK. Just is my opinion.

Forget Windows 7 and Windows 10
Forget Excel 2013 2016 and 365
Forget New computer

Buy an old laptop. Buy an old television ( for second Monitor)
Buy old Office 2003 , 2007 and 2010

All is just my opinion.




Alan

P.S. You can also ask this question here:
https://www.excelforum.com/the-water-cooler/