#1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default User Form

Hello All,

I am trying to create a help form with "Next"
and "Previous" buttons. My form consists of 12 separate
images. I will use a list box to move through the images
(I think I can handle that part). I have the
userForm "activate" hiding all my images except the title
when opened. I need to identify the image that is
visible when the "Next" or "Previous" is clicked so I can
cycle to the next. My images are named img1, img2, etc.

Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default User Form

Hi

Declare a variable outside the subs for that. Replace the Msgbox'es with
something useful:

Dim Limage As Long

Private Sub CommandButton1_Click()
If Limage 1 Then Limage = Limage - 1
MsgBox Limage
End Sub

Private Sub CommandButton2_Click()
If Limage < 12 Then Limage = Limage + 1
MsgBox Limage
End Sub

HTH. Best wishes Harald

"Tim" skrev i melding
...
Hello All,

I am trying to create a help form with "Next"
and "Previous" buttons. My form consists of 12 separate
images. I will use a list box to move through the images
(I think I can handle that part). I have the
userForm "activate" hiding all my images except the title
when opened. I need to identify the image that is
visible when the "Next" or "Previous" is clicked so I can
cycle to the next. My images are named img1, img2, etc.

Thanks in advance



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
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
User form David Excel Programming 0 April 22nd 04 09:21 PM
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form BruceJ[_2_] Excel Programming 2 October 15th 03 05:28 PM
User Form SP Excel Programming 2 July 21st 03 11:34 PM


All times are GMT +1. The time now is 12:28 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"