View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default input box default values (current month, year)

I'm assuming you mean InputBoxes.

Application.InputBox "Enter Month No.","Month", Month(Now), , , , , 1
Application.InputBox "Enter Year","Year", Year(Now), , , , , 1

__________________________________________________ _______________________


"mwam423" wrote in message
...
am using two inboxes to query user to input a month and then a year.
would
like the default values to be the current month and year, i.e., 6 for
june,
and 2007 for year. how can i do this? (just asking for vba for
"default"
argument)