I´m new here, so don´t be angry, if I do something wrong (board-rules), but I´m at the edge of madeness...
Okay to the point:
I have a sheet with a table of a few (hundred) articles.
Now I want to have some Dates in 4 columns:
- Online Date
- Purchase Date
- Payment Date
- Delivery Date
I don´t want to enter some dates directly for each article, when its going online, wenn its purchased...
so I thought I place a checkbox in each cell
If user checks the option the underlying (date-)cell gets the current date and time.
(On uncheck an option dialog asks, whether to remove the date or not)
All its fine with hardcoded cell addresses, but I don´t want to write code for each checkbox seperately.
So I want to get the (reference to) checkbox/buttons underlying cell, to set the date value in that cell.
...so I could use the same code for each ckeckbox.
I´m not familiar with Macro programming, so I ask here whether someone has a pointer for me, how to solve it.
A few programming skills are available on my side
ThanX for any reply!
(Also suggestions are welcome, how to solve it other ways)
ToX