Use List in a macro

[bullcreel]

ActiveCell.Value = ActiveSheet.Range("A1").Value

I have the above macro, and a dozen variations of it on my worksheet. They all work great. My next step is that I want the value in "A1" to be a list, of say at least 7 items. So when i hit the macro, I want it to display the 7 items and I pick one that will display. I have tried different thing except for a User Form. Do I need to do a User Form for this or is there something I can add to my simple macro above?

 

[bullcreel]

So my range that I want to come up is called "Flyouts". When I do this nothing is loaded in the UserForm box. It is blank

 

[steve the fish]

And the code you are using has been changed too?

 

[bullcreel]

OK...I got it to work. I undid everything and redid it. Now may try with a list.

 

[bullcreel]

Reading back through the posts. I intially tried to use a Validation Data dropdown, but couldnt get it to work. The cell will always be activecell because there are different cells I will chose to put this info in.

 

[steve the fish]

Yeah you can have the data validation on lots of cells. The crucial thing is you need to do it prior to use so you would need to know which cells beforehand. With this userform you just need to click the cell you want to add the value to first. Both have advantages and disadvantages.

 

[bullcreel]

Yeah you can have the data validation on lots of cells. The crucial thing is you need to do it prior to use so you would need to know which cells beforehand. With this userform you just need to click the cell you want to add the value to first. Both have advantages and disadvantages.

So if I have to use ActiveCell, I have to use a UserForm. Also, I now need to figure out how to size the UserForm. The range is not in the box until I hit the dropdown arrow. Once I hit that, the range shows up. Then I pick the data I want and hit Command Button; that works fine.

 

[steve the fish]

Yes if you dont know the cell you want to edit beforehand you will need to use the userform. You size it the same place as you created it.

 

[bullcreel]

Yes if you dont know the cell you want to edit beforehand you will need to use the userform. You size it the same place as you created it.

ThankYou once again...great help. Now I have quite a few to develope