Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default for next loop not working

Where is the image control? On a userform or a worksheet

How slow do you want the transition?

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
"Ron Rosenfeld" wrote in message
...
On Fri, 24 Sep 2004 17:24:41 +0100, "Tim"
wrote:

could someone explain why the following simple bit of code does not

work?

Private Sub Image1_Click()
For x = 10 To 1
Image1.Width = x
Next x
End Sub



Try (2nd line)

For x = 10 to 1 Step -1


thanks Ron, it works, but i thought if i did it as a loop, it would have a
smooth transition, it just seems to go from all to nothing in one go

(maybe
i need a line to update the form?)

tim




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
Loop all Sheets not working. Pank New Users to Excel 12 February 27th 07 11:55 AM
On Error GoTo Label in a loop only working once. Ken Johnson Charts and Charting in Excel 4 July 5th 06 09:39 PM
for next loop not working Ron Rosenfeld Excel Programming 0 September 25th 04 04:07 AM
Find value loop not working Christiane[_6_] Excel Programming 3 April 6th 04 01:53 AM
Loop - for each sheet not working? Shetty Excel Programming 6 January 15th 04 02:22 PM


All times are GMT +1. The time now is 06:58 PM.

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

About Us

"It's about Microsoft Excel"