Excel Programming - Macro

G

G&GSolutions

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.
 
B

Bob Phillips

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
 
A

Anthony

Hi,
You can do this displaying a userform asking for the month to be input when
the worksheet opens, or even easier why not just place the formula
=NOW()
and formatt this as 'mmmm' (Format-Cells-Custom then type mmmm into the
'Type' box)
into any blank cell, so when the worksheet opens the current month will be
displayed in your chosen cell
Hope this helps
 
G

G&GSolutions

The excel worksheet is used to enter for example the number of hours worked
in a particular month. So I would like to give a prompt for the user to enter
the month for which they are entering the hours.

How would I use a userform? Can you give me little bit more details please?

Thanks
 
Top