ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scroll through Userform1 Records (https://www.excelbanter.com/excel-programming/339038-scroll-through-userform1-records.html)

Jim May

Scroll through Userform1 Records
 
I've created Userform1 for Entry and have populated
Sheets("mydata").Range("A2:L6") with 5 sample records.

I'd like to now use the SameLook form to be able
to Scroll-through and review each records data.
Q1) Should I create Userform2 (an identical copy of Uf1)and on it Q2) Can I
create Forward / Backward Controls?
Not sure how to do either..
Can someone assist?



Dick Kusleika[_4_]

Scroll through Userform1 Records
 
Jim

http://www.dicks-blog.com/archives/2...heets-part-vi/

This is the last of six posts that describe how to do it.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Jim May wrote:
I've created Userform1 for Entry and have populated
Sheets("mydata").Range("A2:L6") with 5 sample records.

I'd like to now use the SameLook form to be able
to Scroll-through and review each records data.
Q1) Should I create Userform2 (an identical copy of Uf1)and on it Q2)
Can I create Forward / Backward Controls?
Not sure how to do either..
Can someone assist?





All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com