| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On click, copy cell contents to another sheet?
Hi,
Sheet1 has cells c3, c4, c5, c6, c7 which contain the colors: Blue Red Green White Pink When the user clicks on a color, I would like to: a. Copy that color to cell G9 in Sheet3 b. Take the user to Sheet2 How do I do that in VBA code? Thanks, Luther ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I double click a cell, its contents are erased. | Excel Discussion (Misc queries) | |||
| Click on cell to increment contents by 1 | Excel Discussion (Misc queries) | |||
| Copy contents to another sheet | Excel Worksheet Functions | |||
| VBA code to copy cell contents from one sheet to another | Excel Worksheet Functions | |||
| cell contents revert to 0 when i click on the next cell | New Users to Excel | |||
![lothario[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
