Images Gallery in UserForm

[controlz]

Hi All,

i want to add images gallery in the userform below, so the user can browse the user guide images to know how to use the Dashboard
using Next & Previous button to switch between them
could you please give me VBA code for that Purpose or send to me Example Workbook sheet


iuser.jpg



Example for user Guide Images is below




5.gif


Thanks to you all in advance

[dotchiejack]

Something like that?
It is a zip with the excelfile and a folder with images. Unzip it first.

Private Sub Cmd_00_Click()
Unload Me 'close button
End Sub
Private Sub Spb_00_Change()
L_04.Caption = Spb_00.Value 'L_04 is a label Spb_00 is a spinbutton
Im_00.Picture = LoadPicture(ThisWorkbook.Path & "\Images\" & L_04.Caption & ".gif") 'Im_00 is a imagefield
End Sub
Private Sub UserForm_Initialize()
L_04.Caption = 1
End Sub

[controlz]

Dear Dotchiejack,

First point thanks for your prompt reply, i think your method is require to keep images file always beside or with excel sheet, am i right sir ?

second point, i found smart trick to do exactly what i want, let me share it with you

i've created this numbers of Userforms and each one had same buttons (Next, Previous,Close)

1.png

then i used highlighted code below and modified it according to the number of userforms as below

Private Sub CloseButton_Click()
    Unload Me
End Sub

Private Sub Image1_Click()

End Sub

Private Sub Label1_Click()

End Sub

Private Sub Label2_Click()

End Sub

Private Sub NextButton_Click()
UserForm2.Hide
    UserForm3.Show
End Sub

Private Sub PreviousButton_Click()
UserForm2.Hide
    UserForm1.Show
End Sub

Private Sub UserForm_Click()

End Sub

any way this my method and it's works with me magickly, let me know if your method is better than this one

Note : this method not require any temp or saving pic on the PC




Regards,

[Henrik-Chr]

Why not use Userform with Multipli Sides