Results 1 to 10 of 25

Thread: Apply formula Calculation by VBA Value ="to Forumula"

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0
    Thnx Doc Sir for ur Great Efforts
    Doc Sir i am looking to buy a laptop i have serched on google and i have seen forums also but i have not got any exact answer for my question
    Sir i want to know which processor is best for laptop for vba only and graphics card are important or not
    and u r a Proffessional Programmer so Plz help us with the clear picture of which type of laptop or desktop is best for vba programming
    which type of configuration desktop or laptop is suitable for vba programming to achieve great performance(I know the speed of the vba programming depends on vba code but let us assume the code is best and we need to know about the configuration of desktop or laptop )
    Last edited by fixer; 09-16-2019 at 08:15 PM.

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by fixer View Post
    …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




    Quote Originally Posted by fixer View Post
    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/
    Last edited by DocAElstein; 11-15-2019 at 10:39 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!

  3. #3
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0
    vba use how many cores of processor
    so how many cores processor will do etc like this way plz tell me and educate us and plz let me know that which configuration is best

  4. #4
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by fixer View Post
    my question is vba what are the things which are the things that will make a process fast (90% of speed will depend on the code I agree on the same but 10% of the speed will depend on laptop configuration so plz let me know which type of laptop will be best for vba).....vba use how many cores of processor
    so how many cores processor will do etc like this way plz tell me and educate us and plz let me know that which configuration is best
    Sorry, I do not know the answer to those questions
    Alan

    P.S.
    Maybe ask here:
    https://www.excelforum.com/the-water-cooler/
    https://www.mrexcel.com/forum/genera...her-questions/
    https://www.mrexcel.com/forum/lounge-v-2-0/
    Last edited by DocAElstein; 09-18-2019 at 12:33 AM.

Similar Threads

  1. TAT Calculation
    By pramodagroiya in forum Excel Help
    Replies: 5
    Last Post: 05-30-2016, 12:27 PM
  2. On Going Calculation
    By justme1052 in forum Excel Help
    Replies: 2
    Last Post: 12-31-2013, 02:06 AM
  3. Replies: 5
    Last Post: 10-21-2013, 04:43 PM
  4. Calculation with different condition in a cell
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 04-04-2012, 08:38 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •