View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
bdcrisp[_23_] bdcrisp[_23_] is offline
external usenet poster
 
Posts: 1
Default reference an ole image control's .Picture filename?

im using this to initially load all the pictures:

sheets(1).myimage.object.picture = _
LoadPicture("path etc .bmp")

however, when a user clicks on an image
im having this new image 'set' to "clicked image". then, when the use
clicks another image, it replaces with the image clicked first.. do yo
understand?

i would like to say something like:
set oldObj = sheets(1).myoldimage
previousimage = oldObject.object.picture

set newObj = sheets(1).myimage
newObj.object.picture = _
LoadPicture(previousimage)

however.. here, the value of the previous image's .Picture is a lon
integer.. not a path and filename.. i need to reference the image'
path and filename for this progra

--
Message posted from http://www.ExcelForum.com