LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Program so that clicking on a cell will copy that cell to another

I have a list of the next six mondays that I allow a user to see and I want
them to be able to click on any of those 6 cells to display that date into a
different cell that I am using for calculations. As it is now I have them
typing in the date manually by using the 6 listed mondays before to make sure
they choose a monday. How can I generate a hyperlink or command button so
that when they click on the monday they want, it is automatically inserted
into the cell. Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 07. Copy to second cell by clicking f8irst? Pgrudin Excel Worksheet Functions 1 December 4th 07 01:10 AM
How do I edit a cell in Excel without clicking on the cell first? Alisa Excel Worksheet Functions 5 April 2nd 07 07:15 PM
how do i copy data from one sheet to another by d clicking a cell YaYa Excel Discussion (Misc queries) 1 September 19th 06 05:25 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
copy one to cell to another by clicking and dragging mozelle Excel Worksheet Functions 2 May 21st 05 02:30 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"