Forum Discussion

Copper Contributor

Dec 18, 2022

Transforming cell into a button that captures date time stamp for study topics

Hi, I'm trying to create a self-study excel tracker for my mentees. The structure is very simple. Subjects and topics are listed in column A and B. Once A and B is filled, the corresponding cell in C...

developer

Formulas and Functions

Macros and VBA

peiyezhu

Bronze Contributor

Dec 19, 2022

Conditionally transform corresponding cell automatically into a button) Is possible to do this?

as fas as i know not easy in Excel

how about html?

http://e.anyoupin.cn/bsbm/pdo/eh2/a2502/mybookmark/sql/sql/display_table_t.php?find=select+%2A+from+transform_cell_into_button%3B%0D%0Aselect+rowid+old_rowid%2C%2A%2C%27%3Cinput+type%3Dbutton+%0D%0A+value%3D%22start%22+onclick%3DclickSart%28%27%7C%7Crowid%7C%7C%27%29+%2F%3E%3Cspan+id%3Ds%27%7C%7Crowid%7C%7C%27%3E%3C%2Fspan%3E%27+Start%2C%27%3Cinput+type%3Dbutton+%0D%0A+value%3D%22start%22+onclick%3DclickEnd%28%27%7C%7Crowid%7C%7C%27%29+%2F%3E%3Cspan+id%3De%27%7C%7Crowid%7C%7C%27%3E%3C%2Fspan%3E%27+End+from+transform_cell_into_button%3B%0D%0Acli_add_script%7E%EF%BD%9E%0D%0Afunction++clickSart%28rowid%29%7B%0D%0Avar+e%3Ddocument.querySelector%28%27%23s%27%2Browid%29%0D%0Avar+t%3Dnew+Date%28%29.toLocaleString%28%29%0D%0Ae.innerHTML%3Dt%0D%0A%7D%0D%0Afunction++clickEnd%28rowid%29%7B%0D%0Avar+e%3Ddocument.querySelector%28%27%23e%27%2Browid%29%0D%0Avar+t%3Dnew+Date%28%29.toLocaleString%28%29%0D%0Ae.innerHTML%3Dt%0D%0A%7D%0D%0A%EF%BD%9E%3B

AlifOpenSrc

Copper Contributor

Dec 20, 2022

Hi peiyezhu,

Thank you very much for your kind help! The reason I need a button is because the children are only 7 to 12 years of age. This file is meant to be used by the mentors and mentees. The mentors will fill in the link to the resources needed for the visual learning like videos on youtube and then the links to the kinesthetics like online questions. And where they can go are limited by the apps they can use. So only Excel and the authorized browser can work on the devices. Essentially the kids only need to click it. Having a file for each child is imperative. Hence the need for this to be in an excel file. I intend for this to be for parents and orphanages who cannot afford to be there hence this tool. Nonetheless, thank you for your kind solution!

-AOS.