Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 on top of cells) and would like to use a command button to determine the total number of times the picture occurs for a given employee and display the results in cells B18:H18* Jbloggs1 Pic1(B5) Pic2(C5) Pic3(D5) Pic4(E5) Pic5(F5)..to Pic7(K5) CmdBtnJbloggs1 *TotalPic1 TotalPic2 TotalPic3 TotalPic4... There are 7 pics that can appear in any order/frequency up to a maximum of 10 times on top of cells B5:K5. I have also changed the name of the pics to those given above. Does anyone know if this is possible? Any help would be fantastic, Many thanks, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Pictures to return numeric values | Excel Programming | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions |