Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User form | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
User Form | Excel Programming |