Enter today date on other sheet from hyperlink

Giday to you all.
I'm trying to work out the code that when I click on the hyperlink in "Summary" sheet, it will enter the today date on the other sheet ("BriCivic") in A3. I have created a macro button in "BriCivil" sheet that will enter a today date back in the same hyperlink in "Summary" sheet that it will tell us when it is due for the next inspection.
Also is it possible to have the today date not change on the next day?
Please find the attached file with my explanation.
Thanks so much in advance.

If you do not want it to change the next day just add a test.

If the cell is empty add the date if not skip it

Please Login or Register  to view this content.

Now() or Today() adds the full timestamp

You can also use Date

Hi Keebellah
Thank you for replying but I only know VBA a little. I am just a copy programmer.
So where shall I enter your code from hyperlink?
If you can take a good look at the spreedsheet with my comments then you will know what I'm after. It is for inspection on the due date. Also how to enter today date on the next available row down in the same column when clicking on the same hyperlink from "Summary" sheet.
Thank you

Some macros are missing because you have stored then in your PERSONAL.XLSB and that is on your system, so no go for me.
The hyperlink only takes you to the BriCivic worksheet, I would do it with macro and have that macro select the Summary sheet and place the code in A3 as shown earlier.
If you use the value today in the actual date is shwon and will not change anymore.
If you use Today() in a formula it will change every time you open the file.
Can't help you with this since I do not have all the macros like enterDate etc.
Who is going to maintain this if you are just a copy programmer and want to make changes? Ask every time? I suggest a littel basics in VBA, (many free tutorial on online).
There is quiet a nice group of people in Australia : http://www.myonlinetraininghub.com/

Duly noted.
Thanks for info again. I've been on this site for many years now and other members have been greatly helped for me. They always entered the codes in my previous spreedsheets and that's how I've learnt in some cases.
I've never asked again on same subject. No wonder why I couldn't find this in Search regarding adding macro in hyperlink.
Ill take a good look on the site you've given to me but this will not answer my future questions.
So thanks again

I hope you don't mistake my not filling it in as not wanting to, but since not all the macros are available I don't know what might happen and if you get macros with the same name it will hinder the processing.
My goal is also to help people who are starting, I was in your shoes too and time, patience and practice was what it took.
VBA is nothing more than a series of sequential instructions that translate your thoughts step-by-step to carry out what you 'tell' it to do, of course the only language VBA understands is correct VBA syntax.
I was trying to figure out exactly what you are trying to achieve, but am still a little in the dark.
If I can come up with something that helps you I'll post it.

I hope you don't mistake my not filling it in as not wanting to, but since not all the macros are available I don't know what might happen and if you get macros with the same name it will hinder the processing.
My goal is also to help people who are starting, I was in your shoes too and time, patience and practice was what it took.
VBA is nothing more than a series of sequential instructions that translate your thoughts step-by-step to carry out what you 'tell' it to do, of course the only language VBA understands is correct VBA syntax.
I was trying to figure out exactly what you are trying to achieve, but am still a little in the dark.
If I can come up with something that helps you I'll post it.