+ Reply to Thread
Results 1 to 2 of 2

Translate a piece of code from VBA to JavaScript [for Google Sheets]

  1. #1
    Registered User
    Join Date
    03-20-2019
    Location
    Koekelare, Belgium
    MS-Off Ver
    2017
    Posts
    4

    Question Translate a piece of code from VBA to JavaScript [for Google Sheets]

    Hi there.

    I have this piece of code that someone gave me to use for excel VBA, and it's perfect, but it's essential that I can use it in google sheets as well for my work. Only, google sheets uses Javascript, and I understand neither JS or VBA.

    Could someone help me figure this out?

    Please Login or Register  to view this content.
    Thanks in advance
    Last edited by 6StringJazzer; 03-22-2019 at 10:00 AM. Reason: Moved from Excel Programming / VBA / Macros, with permanent redirect

  2. #2
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    123

    Re: Translate a piece of code from VBA to JavaScript [for Google Sheets]

    This code takes the value of what ever cell you have selected, and saves that value to F5. (note that not specifying the sheets you are on gives you a lot of scope for error, but that's another matter)

    The equivalent code in JS would be

    Please Login or Register  to view this content.

    I hope that this helps
    If my solution helped, please consider adding Rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro: translate text from cell using google translate
    By Marc_excel_tips in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-20-2020, 11:46 PM
  2. [SOLVED] Get google translate result from vba?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-25-2020, 02:52 PM
  3. How to scroll through a google sheet using javascript
    By ctgalitzky in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-23-2019, 08:33 PM
  4. Translate text from cell using Google translate (2)
    By Andreea1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2019, 07:36 AM
  5. Google Translate VBA Function
    By beardguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2018, 06:17 PM
  6. Translate from javascript to VBA
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2012, 12:03 PM
  7. running a piece of code in 4 separate sheets
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2010, 05:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1