Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default Picture property


Hi,

The Picture property has been set at design time, but later changed to
another image with the line:-

frmSerial.imgNegLabelA.Picture = frmLabelIcons.Controls(k).Picture

frmSerial.imgNegLabelA. is where I want the image and frmLabelIcons
has a bank of thumbnails.

If the form is closed then reopened the original embedded picture
appears, if the above line is skipped.

What I'd like to do is, without closing the Form, show that original
pictue if (k) is Not Found.

Is this possible? I seem to be heading to the 'item' command but
haven't had any success yet.

Thanks - Kirk
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Picture property

On Sep 14, 6:56*am, kirkm wrote:
Hi,

The Picture property has been set at design time, but later changed to
another image with the line:-

frmSerial.imgNegLabelA.Picture = frmLabelIcons.Controls(k).Picture

frmSerial.imgNegLabelA. is where I want the image and frmLabelIcons
has a bank of thumbnails.

If the form is closed then reopened *the original embedded picture
appears, if the above line is skipped.

What I'd like to do is, without closing the Form, show that original
pictue if (k) is Not Found.

Is this possible? *I seem to be heading to the 'item' command but
haven't had any success yet.

Thanks - Kirk


if frmLabelIcons.Controls.Items.Count < k

is that what you mean?
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default Picture property

On Sun, 14 Sep 2008 01:28:39 -0700 (PDT), NOPIK wrote:



if frmLabelIcons.Controls.Items.Count < k

is that what you mean?


I don't think so... k isn't a number... but if it were I'd still
need to set the picture to the default (the one assigned at design
time).

How's that done? Anyone know?

Thanks - Kirk
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manually changing a picture (shape) name property ker_01 Excel Discussion (Misc queries) 4 April 3rd 23 07:01 PM
Runtime Error 1004 Unable to set the top property of the picture c JB Bates[_2_] Excel Discussion (Misc queries) 1 March 3rd 10 08:04 PM
Where does excel store the pictures of a userform's 'Picture' property? zz Excel Programming 5 January 21st 07 02:35 AM
changing property of a picture that is already pasted on excel cc New Users to Excel 0 June 27th 06 05:04 AM
Picture Tiling property Tom Ogilvy Excel Programming 0 February 1st 04 08:36 PM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"