Filling in tentative times in a cell.

[mindz]

I'm trying to make it easier for my mother to fill in a spreadsheet i made and have it stored on my OneDrive folder. This way I can check and make sure she's taking her meds as needed just by glancing.

sometimes she doesn't do well with times. One med she takes when she gets up, then another just before bedtime. But she also has some that are based strictly on 8 spreads
What I did was create a name set with times that she can pick from a dropdown when she takes them. But what I want to do is be able to highlight the next cell with the time she is taking her meds, +8 hours, just greyed out. Like a form with a default value that disappears when they select the cell to enter the real time

I have trouble with this 1. because it's a time add, and I haven't quite figured it out, and 2. I'm not that familiar with Excel.

Is this a simple task?

[bsalv]

Is your mother working with a PC or something else ?
This is to know of VBA (macros) are allowed to make tasks easier.

[mindz]

Is your mother working with a PC or something else ?
This is to know of VBA (macros) are allowed to make tasks easier.

Thanks for the replly!

she uses a home PC. I take care of her so I moved her back to her hometown and I stay here now too (she's going blind). But I'm gone at work and sometimes I stay out late if things are great.

It's really nice to have a spreadsheet I can pop into that's shared so I can see at a glance if she's keeping up, and that she's on track.

if you've got a better suggestion on how to do this, I'm all ears. Well I guess I'd be all eyes

This is what I have for the time being ( and her entry times are all over the place, but at this point I'm just getting her used to using it. getting stable comes next
dbQniRM.jpg

[bsalv]

just a trial

in the first 3 columns, you fill date time and the kind of medication
When the scheduled time for the medication is there, you find it in the textbox.
When that medication is taken, click on the green commandbutton.

Later, to prevent errors by your mother, these first columns can be moved to a separate sheet.

Every 5 minutes the macro runs once, next time is displayed in cell T1