View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_542_] Simon Lloyd[_542_] is offline
external usenet poster
 
Posts: 1
Default Date/Time Stamp Macro Button Problem

As simple as possible???.......ok try this!

Choose a cell you wont use, lets say A1 now type =NOW()and pres
return, the current date and time will now be displayed here.

Select the area's you want the date stamp to appear in eg. columnA hol
down CRTL and choose another column or group of cells and so on, no
right click and choose FORMAT, NUMBERSand then CUSTOM scroll down unti
you see dd/mm/yyyy hh:mm and choose this......., when you have done thi
choose DATA from the menu bar and then choose VALIDATION and then fro
the allow selection choose LIST a pop up box will appear now click th
cell we have NOW in (A1) then click the red and grey square to th
right of the formula bar on the pop up box. Now when you select an
cell in your selected range an arrow will appear at the side of th
cell if you click this and then choose the only entry there is it wil
date stamp that cell.

HTH

Simo

--
Message posted from http://www.ExcelForum.com