Thanks Boss i edited the picture and its working nicely now, so grateful to you. i have made three images ie image1 ,image2 and image3 so that if you select image1 the others will not be seen, however the macro seem not to be hiding the other two images when one is selected. i have deleted the images cos of size its not allowing me to send them over. pls assist. thanks
Sub picload()
Dim UserNum As Double
UserNum = Sheet1.Range("A11").Value
Select Case UserNum
Case 1
If UserNum <> 1 Then
Sheet1.Image1.Visible = False
Else: Sheet1.Image1.Picture = LoadPicture(Sheet1.Range("B1"))
End If
Case 2
If UserNum <> 2 Then
Sheet1.Image2.Visible = False
Else: Sheet1.Image2.Picture = LoadPicture(Sheet1.Range("B1"))
End If
Case 3
If UserNum <> 3 Then
Sheet1.Image3.Visible = False
Else: Sheet1.Image3.Picture = LoadPicture(Sheet1.Range("B1"))
End If
End Select
End Sub
On Mon, Feb 24, 2014 at 10:54 AM, Ravinder <ravindervbacli...@gmail.com>wrote:
> Its working perfectly, I am not getting whats the problem.....
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey
> *Sent:* Monday, February 24, 2014 3:59 PM
> *To:* excel-macros
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ VBA Code to access pictures from drive C
>
>
>
> EXCELLENT BOSS 100% OF WHAT I WAS ASKING FOR, THANK YOU VERY MUCH, just a
> slight issue, when i change a picture, it doesnt show unless you click on
> the picture, immediately you remove the mouse it goes off. can you help out
> thanks.
>
>
>
> On Mon, Feb 24, 2014 at 5:50 AM, Ravinder <ravindervbacli...@gmail.com>
> wrote:
>
> [image: Image removed by sender. Boxbe]
> <https://www.boxbe.com/overview>[image:
> Image removed by sender.]This message is eligible for Automatic Cleanup! (
> ravindervbacli...@gmail.com) Add cleanup
> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dmxzoh91MSk53EdTMziPN%252FkuYDGaNSdatQsTBsy4tiCfboLhgm0dHsA5UR9jfOxrFqdhtKAN9DxV3gg7WinFWpMl5TNTSweSXA99nw6RmFHKVk3pmpKuzVX0NsCNFVNNYcRELyYeSrFLsQZAtSTorLQ%253D%253D%26key%3D8TU5pW5zVBM3S2Ne5FbUbfqM6QRQZFEdlj2IELXglMc%253D&tc_serial=16451535855&tc_rand=1136612410&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>|
> More
> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=16451535855&tc_rand=1136612410&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>
>
>
>
> Pfa, if help
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey
> *Sent:* Sunday, February 23, 2014 9:56 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ VBA Code to access pictures from drive C
>
>
>
> Hello Experts,
>
>
>
> embedding pictures in excel sheet can take a lot of size so i need an
> assistance with a code to access pictures based on a drop down selection.
> ie assuming i have a combo box with three names a, b and c, if i select a i
> want to link it to a particular picture on the c drive. kindly assist with
> code. thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
<<inline: ~WRD000.jpg>>
PICTURE FROM DRIVE C.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
