| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Pictures to return numeric values
Dear Forum Members,
I am trying to achieve something rather abstract using VBA code and I'm not entirely sure if its possible, hence any help would be greatly appreciated. Instead of using numeric values in cells I have represented some data pictorially (by pasting various .jpg's within cells) and would like to use these pictures to calculate some numeric totals - I know its probably hard to visualise how the spreadsheet looks so I have provided a summarised format below; Ranking (1 to 10) Name 1 2 3 4 . . . Name1 Pic1 Pic7 Pic1 Pic4 cell range B5:K5 Name2 Pic2 Pic2 Pic2 Pic4 ... ... Totals Pic1 Pic2 Pic3 Pic4 . . . all pics displayed,7 in total CmdBtn_Name1* Total (2) Total (0) Total (0) Total (1) "Total" cell range B18:H18 CmdBtn_Name2* Total (0) Total (3) Total (0) Total (1) * Upon hitting each CmdBtn I would like the total number of each picture in range B5:K5 to be displayed in the total cell range (B18:H18) and so forth. Any help with the code for the CmdBtn's would be fantastic, Many thanks & best wishes Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Return Numeric Labels that have Values =4 across Single Row | Excel Worksheet Functions | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Return Single Instance of Numeric Values from a Column | Excel Worksheet Functions | |||
Threaded Mode
