Have you tried Data Validation?
You can use this to put a list into a cell for selecting different options.

--
steveB

Remove "AYN" from email to respond
"Anton Sommer" wrote in message
...
Hello folks,

is it possible to place any object (i.e. Pull down menu or checkbox) in a
cell of a table. And then of course beeing able in vba to read out the
values like any other object in a userform.
Is there an event to use in vba to find out if a user has just left a cell
like the lost focus event of a textbox?

Thank you folks,


Anton