Results 1 to 2 of 2

Thread: VBA to Javascript
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb VBA to Javascript

    Hej Guys.
    I made a little VBA-script i now i need it translated to Java script.
    I made it in excel and now i need to use it in google sheets.

    The VBA code is this:

    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim B As Range: Set B = Range("B:B")
    Dim v As String
    If Target.Column Mod 3 = 1 Then Exit Sub

    Woorksheet3.Unprotect Password:="abc"


    Application.EnableEvents = False
    v = Target.Value
    If v = "x" Then Target.Offset(0, 1) = Now()
    If v = "1" Then Target.Offset(0, 1) = Now()
    Application.EnableEvents = True

    Woorksheet3.Protect Password:="abc"


    End Sub

    Hope someone can help!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,196
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: VBA to Javascript

    Well if you wrote it, you know what it does and how it works.
    So shouldn't this request be in a Javascript forum?

    That's like writing a story in French, wanting to translate it into German, but posting it to a French forum ???
    Last edited by Special-K99; Jul 19th, 2019 at 09:57 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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