Hi
Your question is very vague. You can normally access a calander
control in Excel (really part of Access, but most people have that too
so you can use it in Excel) either on a worksheet or on a Userform.
You can use this to pick a date which can then be placed in a
worksheet cell with any format you like.
Is that what you want??
regards
Paul

On May 29, 5:03 am, Newatit wrote:
What would be the basic approach to creating a monthly lookup table that
would allow the user to select the text value for the month and return the
numerical value to the cell.
Can this be done solely within excel or does it involve interaction with
something such as VB?

Thanks