I am using Windows XP with Office 2003.

1. I need a VBA method to enter edit mode within a cell. As though the user
double clicked in a cell or pressed F2. Or must I use send keys?

2. Is there a way to capture the user's previous selection? For example,
user makes a selection one, then makes selection two. I need the range
address for selection one.

Could someone please post example code for these questions?

Thanks much in advance.