 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2007lookuppictures
I downloaded a sample file on lookuppictures from McGimpsey and Associates. The file gives information regarding looking up and displaying a picture based on cell value. I have two questions. 1. In the file the pictures are named as picture 1, picture 2, etc. Can we change the name of the pictures? if so how? 2. How many such pictures can we load on a excel file? Is there any limit? With sincere Thanks Sridhar > I downloaded a sample file on lookuppictures from McGimpsey and Associates. > The file gives information regarding looking up and displaying a picture > based on cell value. I have two questions. > 1. In the file the pictures are named as picture 1, picture 2, etc. Can we > change the name of the pictures? if so how? One way: Select the picture. Change the name in the name box (left side of the formula bar). > 2. How many such pictures can we load on a excel file? Is there any limit? IIRC, it's as many as your system resources allow. Thank you Mr. JE McGimpsey for your details. Can you please something more about storing pictures? What is IIRC? With regards Sridhar > > I downloaded a sample file on lookuppictures from McGimpsey and Associates. > > The file gives information regarding looking up and displaying a picture [quoted text clipped - 10 lines] > > IIRC, it's as many as your system resources allow. Acronym for "If I Remember Correctly"  SignatureRegards, Peo Sjoblom > Thank you Mr. JE McGimpsey for your details. Can you please something > more [quoted text clipped - 20 lines] >> >> IIRC, it's as many as your system resources allow. Thanks Mr. Sjoblom. I thought it was a code in computer language. With regards Sridhar > Acronym for "If I Remember Correctly" > [quoted text clipped - 22 lines] > >> > >> IIRC, it's as many as your system resources allow. Thanks Mr. McGimpsey. I changed the names of the pictures from picture no(1,2) to School no. The pictures got missing. The VB code is giving me error. "invalid use of me.pictures". What i have to change in the code to regain the pictures. Thanking you Sridhar > > I downloaded a sample file on lookuppictures from McGimpsey and Associates. > > The file gives information regarding looking up and displaying a picture [quoted text clipped - 10 lines] > > IIRC, it's as many as your system resources allow. Sounds like you inadvertently deleted the pictures. Repaste them in. > Thanks Mr. McGimpsey. I changed the names of the pictures from picture > no(1,2) to School no. The pictures got missing. The VB code is giving me > error. "invalid use of me.pictures". What i have to change in the code to > regain the pictures. Thank you Mr. McGimpsey. Its my mistake. I changed the name of the picture but i forgot to do the same in the table. I got it. Sorry for the trouble. Sridhar > Sounds like you inadvertently deleted the pictures. Repaste them in. > > > Thanks Mr. McGimpsey. I changed the names of the pictures from picture > > no(1,2) to School no. The pictures got missing. The VB code is giving me > > error. "invalid use of me.pictures". What i have to change in the code to > > regain the pictures. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.