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?
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?