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)
|