input box default values (current month, year)

G

Guest

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

Vasant Nanavati

I'm assuming you mean InputBoxes.

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

_________________________________________________________________________
 
C

Corey

Dim res As Variant
res = InputBox("What is the Year ?", , "2007")
Sheet1.Range("A1") = res

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

Vasant Nanavati

This won't work next year. :)
________________________________________________________________________
 
V

Vasant Nanavati

You're most welcome. :)
________________________________________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Hello happy new year to all, Text box input for year of purchase 0
current week, current month, current year 1
Access 2 Digit year in Access Text Box 3
Textbox mask for textboxes in my Userform (Excel 2007) 5
Calculating age at different points in time 1
Check Input for Valid Month 4
use ComboBox value to select range and then use selected range tocreate a chart 3

Top