Hi,
I'm trying to create a macro that can pull the next item in a list or the item before. For example, in the attachment, in D2, we have A, but if click "Next", it'll jump to "B" and return "2" in D4. Additionally, we hit "back," it'll go back to "A" again.
As always, thank you so much for the help!
sample.xlsx
Last edited by janeml; 01-23-2014 at 06:06 PM.
Something like this?
Please Login or Register to view this content.
try this code ,
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Hi,
Yes, that's the code I'm looking for. However, since it's a private sub code, how do I place it into my actual workbook and have it work?
Thanks!
remove the word private from the code
the code doesn't work if i remove the "private"
you have assign the sub procedure to the icon. Easier if you attach your working file.
Re: Pulling next item in a list
Originally Posted by JieJenn
Hi JieJenn,.
I assigned the sub procedures to the icons. I'm tryin gto upload a clean copy of the working file, but it's too big
Don't know how to help you. Can you just attach a sample of what you've done?
Hi Jiejenn,
I had to strip all the hidden tabs. The icons are in "tech_detail" and the list of names are in "q5_report"
Tech_Performance_Dashboard_jl.xlsm
Move your declaration of variable to the top
Dim rngData As Range
Dim f As WorksheetFunction
Last edited by JieJenn; 01-23-2014 at 05:51 PM. Reason: Adding Attachment
Re: Pulling next item in a list
Thank you thank you thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks