Link to home
Start Free TrialLog in
Avatar of kaosyeti
kaosyeti

asked on

Java help for an Excel person, please.

What I'm trying to do is to attach a macro to a button (which I can do) that changes the contents of a range of cells based on whether or not they contain numbers.  Like ticking off a to do list, in a sense.  The cells in range D11 through W15 (5 rows of 20) are each numbered 1 through 100.  Upon clicking the button, I would like to make a script that checks the first cell is still a number and if so, change the cell value to "X" instead.

I have no experience with java but plenty with VBA and am now in a new job where I can only use google sheets instead of excel.  I can imagine ways to do this with a for next loop or a while wend loop but I don't even know the syntax for java, let alone what commands and functions it has to do this.  Thanks, experts!
Avatar of Norie
Norie

Do you mean Javascript?
Avatar of kaosyeti

ASKER

Umm..  maybe?  Whatever language scripts are written in for google sheets.  I'm not familiar with either to the point of not knowing there is a difference. (I do know VBA quite well.  I'm not bragging, but I'm not technologically incoherent either.  Just never did anything with Java/Javascript).
Could you attach an example workbook?
This is the sheet I'm trying to automate with a button to change one number in the range to an X with each click event.
Blank-Activity-Log.zip
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.