I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
last match refers to a column range and posts the contents of that cell in my
worksheet, But I can not get the picture in ANY format to paste into a
cell... How do I do this type of operation??
That's because cells can't contain pictures. Pictures exist on the
drawing layer above the cells. Cells contain formulae or values.
You might be able to use something like the technique here:
http://www.mcgimpsey.com/excel/lookuppics.html
In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> last match refers to a column range and posts the contents of that cell in my
> worksheet, But I can not get the picture in ANY format to paste into a
> cell... How do I do this type of operation??
ok so I used your recommendations and it works perfectly... BUT... there is
one picture I want to show all the time ... how do I do that??
"JE McGimpsey" wrote:
> That's because cells can't contain pictures. Pictures exist on the
> drawing layer above the cells. Cells contain formulae or values.
>
> You might be able to use something like the technique here:
>
> http://www.mcgimpsey.com/excel/lookuppics.html
>
> In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
> DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
>
> > I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> > MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> > last match refers to a column range and posts the contents of that cell in my
> > worksheet, But I can not get the picture in ANY format to paste into a
> > cell... How do I do this type of operation??
>
One way would be to put this line after the
End With
line.
Me.Pictures("MyVisiblePic").Visible = True
In article <C1F87EC1-E58B-43FD-8841-CE8A09561A67@microsoft.com>,
DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> ok so I used your recommendations and it works perfectly... BUT... there is
> one picture I want to show all the time ... how do I do that??
>
>
> "JE McGimpsey" wrote:
>
> > That's because cells can't contain pictures. Pictures exist on the
> > drawing layer above the cells. Cells contain formulae or values.
> >
> > You might be able to use something like the technique here:
> >
> > http://www.mcgimpsey.com/excel/lookuppics.html
> >
> > In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
> > DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> >
> > > I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> > > MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> > > last match refers to a column range and posts the contents of that cell
> > > in my
> > > worksheet, But I can not get the picture in ANY format to paste into a
> > > cell... How do I do this type of operation??
> >
Ok so I put this after the end with line and I get a run time error
"Me.Pictures(Picture6).Visible = True" the complete code is this and I need
to have picture6 visible all the time.
"JE McGimpsey" wrote:
> One way would be to put this line after the
>
> End With
>
> line.
>
> Me.Pictures("MyVisiblePic").Visible = True
>
>
> In article <C1F87EC1-E58B-43FD-8841-CE8A09561A67@microsoft.com>,
> DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
>
> > ok so I used your recommendations and it works perfectly... BUT... there is
> > one picture I want to show all the time ... how do I do that??
> >
> >
> > "JE McGimpsey" wrote:
> >
> > > That's because cells can't contain pictures. Pictures exist on the
> > > drawing layer above the cells. Cells contain formulae or values.
> > >
> > > You might be able to use something like the technique here:
> > >
> > > http://www.mcgimpsey.com/excel/lookuppics.html
> > >
> > > In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
> > > DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> > >
> > > > I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> > > > MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> > > > last match refers to a column range and posts the contents of that cell
> > > > in my
> > > > worksheet, But I can not get the picture in ANY format to paste into a
> > > > cell... How do I do this type of operation??
> > >
>
Opps forgot the code....Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("H1")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
Me.Pictures(Picture6).Visible = True
End Sub
"JE McGimpsey" wrote:
> One way would be to put this line after the
>
> End With
>
> line.
>
> Me.Pictures("MyVisiblePic").Visible = True
>
>
> In article <C1F87EC1-E58B-43FD-8841-CE8A09561A67@microsoft.com>,
> DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
>
> > ok so I used your recommendations and it works perfectly... BUT... there is
> > one picture I want to show all the time ... how do I do that??
> >
> >
> > "JE McGimpsey" wrote:
> >
> > > That's because cells can't contain pictures. Pictures exist on the
> > > drawing layer above the cells. Cells contain formulae or values.
> > >
> > > You might be able to use something like the technique here:
> > >
> > > http://www.mcgimpsey.com/excel/lookuppics.html
> > >
> > > In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
> > > DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> > >
> > > > I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> > > > MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> > > > last match refers to a column range and posts the contents of that cell
> > > > in my
> > > > worksheet, But I can not get the picture in ANY format to paste into a
> > > > cell... How do I do this type of operation??
> > >
>
Picture6 is the name of the picture?
Me.Pictures("Picture6").Visible = True
DarnTootn wrote:
>
> Opps forgot the code....Private Sub Worksheet_Calculate()
> Dim oPic As Picture
> Me.Pictures.Visible = False
> With Range("H1")
> For Each oPic In Me.Pictures
> If oPic.Name = .Text Then
> oPic.Visible = True
> oPic.Top = .Top
> oPic.Left = .Left
> Exit For
> End If
> Next oPic
> End With
> Me.Pictures(Picture6).Visible = True
> End Sub
>
> "JE McGimpsey" wrote:
>
> > One way would be to put this line after the
> >
> > End With
> >
> > line.
> >
> > Me.Pictures("MyVisiblePic").Visible = True
> >
> >
> > In article <C1F87EC1-E58B-43FD-8841-CE8A09561A67@microsoft.com>,
> > DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> >
> > > ok so I used your recommendations and it works perfectly... BUT... there is
> > > one picture I want to show all the time ... how do I do that??
> > >
> > >
> > > "JE McGimpsey" wrote:
> > >
> > > > That's because cells can't contain pictures. Pictures exist on the
> > > > drawing layer above the cells. Cells contain formulae or values.
> > > >
> > > > You might be able to use something like the technique here:
> > > >
> > > > http://www.mcgimpsey.com/excel/lookuppics.html
> > > >
> > > > In article <B018BBC5-2841-4569-A488-B16525CCE8AE@microsoft.com>,
> > > > DarnTootn <DarnTootn@discussions.microsoft.com> wrote:
> > > >
> > > > > I am using this formula in a cell "=INDEX(Crew!$A$1:$G$25,
> > > > > MATCH(G12,Crew!$A$1:$A$25,), MATCH("LOGO",Crew!$A$1:$G$1,))" where as the
> > > > > last match refers to a column range and posts the contents of that cell
> > > > > in my
> > > > > worksheet, But I can not get the picture in ANY format to paste into a
> > > > > cell... How do I do this type of operation??
> > > >
> >
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks