Single Cell Rotating List?

**brolsen** · 09-09-2011, 09:47 AM

Hello All,

I was wondering if someone could help me develop a rotating list macro or something that will allow data from one column from a seperate sheet to display one at a time on another sheet, with a "Next" button to view the next item. For example's sake imagine this:

In sheet 1 I want Cell A1 to display data from Sheet two in a list.

Let's say Sheet 2 column A has the following list:
Mouse
Cat
Dog
Cow
Horse
Bird
Bug

I would want A1 to display only Mouse until I hit a "Next" button, then it would display "Cat," then Next would display "Dog," etc... Once at the end of the list (i.e. Bug) I would want the Next button to go back up to the top and display Mouse again.

Is this possible? Any help would be greatly appreciated!

**Kelshaer** · 09-09-2011, 10:20 AM

Try this in the Command button code
rename your command button to "cmdNext"
Dont forget to mark the post as [SOLVED] if it was

Please Login or Register  to view this content.

I have attached the file for you

**MickG** · 09-09-2011, 10:58 AM

Try this:-

Please Login or Register  to view this content.

Mick

**brolsen** · 09-09-2011, 04:49 PM

Thanks for the help, anytime I try to run the code I get an error that says:
Compile Error: Invalid Outside Procedue

Any clue what I am doing wrong?

I opened your excel, hit design view, added your code to the button, then I am apparently stuck there. When I click on the button in design mode, the Name Box does say "cmdNext"

**MickG** · 09-10-2011, 09:55 AM

Place a Button from the "Forms" toolbar (Not ActiveX") on sheet1 (Results sheet
You will know if its a forms Button because the word "Button1" will will show on its Caption.
When you place the Button on the sheet ,the Macro dialog box will appear. Click "New from the Menu on side of box .
The VB editer will appear.
Paste the code into the Vb window

Please Login or Register  to view this content.

Each time you click the Button a new value from list in sheet(2) column "A" will appear.
Regards Mick

**Kelshaer** · 09-13-2011, 09:08 AM

the sheet i sent already contains the button. just press it.

**snb** · 09-13-2011, 09:42 AM

No buttons, but doubleclicking in cel A1:

Please Login or Register  to view this content.

**brolsen** · 09-13-2011, 10:45 PM

MickG's second post helped a lot and it worked.

Kelshaer, I tried yours and when I opened it nothing happened.

Thanks for everyone and your help! You all are the best!