Thread: input box default values (current month, year)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mwam423 mwam423 is offline
external usenet poster
  
Posts: 103
Default input box default values (current month, year)
so simple! thank you, and appreciate the quick reply


"Vasant Nanavati" wrote:

I'm assuming you mean InputBoxes.

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

Reply With QuoteReply With Quote