Home > Excel Tutorial > Calling Image With Combobox

Calling Image With Combobox

Calling Image From Another Page

– Firstly let’s create picture names and pictures. Let’s place picture names and pictures without overflow into the cells .(see “resim” page)

– Let’s define Name- it is Liste :

Liste=OFFSET(resim!$B$1;1;0;COUNTA(resim!$B:$B)-1;1)

– Let’s use “Liste” name  for data validation in C8 and bottom cells.

– Let’s create the field names for  to be displayed pictures in each cell . Here ,you can use the field name you want :

Resim1a =OFFSET(resim!$C$2;MATCH(Weather!$C$8;Liste;0)-1;0;1;1)

Resim1p =OFFSET(resim!$C$2;MATCH(Weather!$C$9;Liste;0)-1;0;1;1)

Resim2p =OFFSET(resim!$C$2;MATCH(Weather!$C$11;Liste;0)-1;0;1;1)

Resim2t =OFFSET(resim!$C$2;MATCH(Weather!$C$12;Liste;0)-1;0;1;1)

Resim3t =OFFSET(resim!$C$2;MATCH(Weather!$C$13;Liste;0)-1;0;1;1)

– Let’s copy pictures and place to D8, D9, D10, D11 and  D12  cells.

– Let’s select D8 cell, later let’s write the field name we given  to formula bar :

=Resim1a

call_image

Click Here To Download Template (in my other blog)

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: