View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Excel Programming - Macro

Why get the user to enter it, you can use the Date function to get
information about today, such as

Month(Date)

Day(Date

Year(Date)

and so on

--
__________________________________
HTH

Bob

"G&GSolutions" wrote in message
...
When the user opens my worksheet, how would I prompt the user to enter the
current month before accessing anything on the worksheet. Later I need to
use
this month input in the worksheet to provide them the days & date
information.