Replacing cells with other cells

[Gina]

I have recently set up a time sheet for myself at work. At my last place you
could click on a button called 'Annual Leave' or 'Bank Holiday' and the cells
would be filled with a standard day. Does any one know how this is done? I
would like to add it to my time sheet if poss.

 

[Gina]

Sorry - I forgot to say that I'm currently using 2003.

 

[Gord Dibben]

Is a standard day 8 hours?

Sub holiday()
ActiveCell.Value = 8
End Sub


Gord Dibben MS Excel MVP

 

[Gina]

A standard day is 07:30 hours
--
Gina

Is a standard day 8 hours?

Sub holiday()
ActiveCell.Value = 8
End Sub


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Adjust macro value to suit.


Gord

 

[Gina]

Thank you.
--
Gina

Adjust macro value to suit.


Gord