Can Excel have this type of Form

[AlexanderBB]

Like Access, where record selectors are shown?
I want to have a picture viewer where a bunch of images can be cycled.
I was thinking of using the whole Form size for the picture, but this makes it hard to have a way of moving to the next, last etc.
Any ideas would be most welcome.

 

[Edgar_]

First, make a ListObject table, this example uses one column. Then, create your form, add a image control, a previous button and a next button. Finally, adapt this code with your names and add it to your form:

Option Explicit

Private r As Long, count As Long

Private Sub PreviousImageButton_Click()
    r = IIf(r = 1, count, r - 1)
    UpdateImage
End Sub

Private Sub NextImageButton_Click()
    r = IIf(r = count, 1, r + 1)
    UpdateImage
End Sub

Private Sub UserForm_Initialize()
    r = 1
    count = [PathsTable].ListObject.ListRows.count
    UpdateImage
End Sub

Private Sub UpdateImage()
    Me.Image1.Picture = LoadPicture([PathsTable].ListObject.DataBodyRange(r))
End Sub

That should cycle.

 

[RoryA]

Like Access, where record selectors are shown...I was thinking of using the whole Form size for the picture, but this makes it hard to have a way of moving to the next, last etc.

First, as a general rule, I'd say if you are thinking of doing something that makes everything else difficult, it's usually best to rethink.

Second, an Access form doesn't really use the whole form for any one thing. There are sections for the record selector, and the navigation items. I don't see why you couldn't create a similar looking thing in a userform.

 

[Edgar_]

Alexander just need records, hence the list object.
Buttons are also necessary to cycle, hence the previous and next button.

That's it for what the Access form does. Since the requirement doesn't really cover any necessity about record selectors or events, only navigation, the code above takes care of it.