+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - VBA help!

  1. #1
    Registered User
    Join Date
    04-05-2018
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    11

    Google Sheets - VBA help!

    In a prior thread, I was provided the below VBA script to use for my spreadsheet. which worked wonderfully. However, I also need this to work in google sheets. can anyone help me instruct me on how to load it/convert it so that it will also work in google sheets?

    I can't post the direct link to my previous post, but it can be found here - excel-formulas-and-functions 1228139-array-help-using-index-if-match-etc # post4886052

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Google Sheets - VBA help!

    JenMaster if it helps here's the direct link.

    https://www.excelforum.com/excel-for...ml#post4886094
    Dave

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Google Sheets - VBA help!

    VBA is proprietary to Microsoft. So no. It isn't possible to directly convert it to work for Google Sheet.

    Google sheet uses Google Script, a variant of JavaScript.

    But taking quick look at your sheet, you dont even need script/UDF for that.
    Excel 2016 has CONCAT & TEXTJOIN (for Office 365 subscription only), which is supercharged CONCATENATE, and works much like UDF used in your workbook.
    Google sheet also has JOIN() function which will do much the same.

    Try... below in Google Sheet.
    Please Login or Register  to view this content.
    Last edited by CK76; 04-20-2018 at 04:10 PM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Google Sheets - VBA help!

    Hey CK76. Glad to see someone chime in on this one.

    TEXTJOIN would be simpler, but OP has Excel 2007. Too bad.

  5. #5
    Registered User
    Join Date
    04-05-2018
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Google Sheets - VBA help!

    Fantastic! Thank you! I am new to using google sheets - that formula did work how I wanted once I added the second criteria!

+ 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. Google Sheets: transfer for excel to sheets formular not more working
    By KJ_2016 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-28-2016, 03:40 AM
  2. Importing from excel to Google sheets formula not working
    By dori2o in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-31-2016, 10:28 AM
  3. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  4. Google Sheets - Using IF and SPLIT together?
    By dracogram in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 07-16-2014, 09:57 PM
  5. Replies: 1
    Last Post: 01-25-2014, 02:10 PM
  6. Google (sheets, forms, etc)
    By BRIZZLE101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-03-2013, 08:55 PM

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