Fine tuning a macro...

[cafc_fuller]

Hello,

Using this website and my knowledge i have made the following Macro:

Sub Button_Click()
Range("D15").Value = "COMPLETED"
Range("H43").Value = Date
Range("C16").Formula = "=Delivery!$C$16"
Sheets(Array("Delivery")).PrintOut Copies:=1
End Sub

However I want this to run when Cell E5 is clicked on.
Also the date is currently displayed as 30/07/2013.
I would like the date to display 30.07.13 - is there any way to change this?

Thanks
Darren

[Norie]

Try this, which goes in the worksheet module.

Please Login or Register  to view this content.

[cafc_fuller]

Sorry this doesnt seem to be working? Do i need to add any other code to this?

Thanks
Darren

[cafc_fuller]

Does this code you sent include the e5 cell part?

Thanks

[Norie]

Darren

Where exactly did you put the code?

[cafc_fuller]

I created a macro and copy and pasted the code in exactly how it was above - is that wrong?

Thanks
Darren

[Norie]

Darren

Yes, but so's my code.

I thought it was D5 not E5.

Here's the amended code.

Please Login or Register  to view this content.

To use this code right click the tab of the worksheet where you want to click E5 and select View Code.

You should now see the worksheet's module.

Paste the code in there and close VBE (ALT+Q) to return to Excel.

Now when you click on E5 the code should run.

[cafc_fuller]

That's great - thank you so much works perfectly!