| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Formula based in cell user clicks
In need to insert a simple formula into Column J based on the cell in the
same row which is clicked by the user. Only one of the cells will be clicked and color changed between the following cells F,H,L,M or N. The formula is the product of 3 cells, 2 of which are fixed and the last one should become whichever cell the user clicks. e.g. Cells(j, "J") = Cells(j, "E") * Cells(j, "I") * clicked cell(either cell F, H, L, M or N) Is this possible to do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| confirmation window once user clicks submit on user from | Excel Programming | |||
| Pause While User Clicks on Chart Series | Excel Programming | |||
| How to have errr msg pop up when user clicks on locked cell | Excel Discussion (Misc queries) | |||
| creating popup menu when user right-clicks on cell | Excel Programming | |||
| Counter for user clicks | Excel Programming | |||
Threaded Mode
