Option for cells

[TjoemTjoem]

I'm not sure how to explain it but I accidently clicked a hotkey that showed me what i typed in a cell previously.
It's hard to explain it in words so i'll explain it with an example, imagine that:

a1 says Card number 72
a2 says card number 73
a3 says card number 74

Then I selected cell a10 and I clicked a hotkey which gave me a dropdown list with Card number 72, Card number 73 and Card number 74.

Sorry for not being clear.

Hope that you guys can help me.

[mehmetcik]

This can be done quite easily

What you need is a sheet specific macro

The Macro remembers the last few cell changes.

If you double click on a cell a userform opens that lists these changes.

Clicking on the userform saves the selected value into the cell.

Easy really.



Ok you need four pieces of code.

These two are sheet specific.

Right click on the sheet name at the bottom of excel and paste there:-

Please Login or Register  to view this content.

The next two are in the Userform.

Please Login or Register  to view this content.