Prepopulated inputbox with current fiscal year, month, day

**jwlamb** · 10-07-2013, 01:00 AM

~~ Correction, Fiscal year is not needed. Calender year please.

I am working on a work project so that when a user clicks a command button, it clears all daily data out of a log to create a new log for the next cylce. Everything works in my code, but I was wondering if there was a way to pre-populate the inputbox so the user doesn't have to type as much into the box, just verify that it is correct and add the next number. Our daily numbers go YY MM DD ABC ###. The ### only changes when we have multiple missions per day, so this would be user inputted. The "ABC" is always "ABC", YY MM DD is the two digit year, month, day.

Thank you!!

Please Login or Register  to view this content.

**patel45** · 10-07-2013, 01:47 AM

Please Login or Register  to view this content.

**jwlamb** · 10-07-2013, 01:52 AM

I can't get that to work. Where do I put that into the code?
Thank you.

Originally Posted by patel45

Sub a()
populate = "ABC " & Format(Date, "yy-mm-dd")
response = InputBox("Prompt", , populate)
End Sub

**jwlamb** · 10-07-2013, 02:05 AM

I got it to work, thank you. But is there a way to adjust it for a different time zone? (Zulu time) Thank you,

Originally Posted by jwlamb

I can't get that to work. Where do I put that into the code?
Thank you.

**patel45** · 10-07-2013, 03:01 AM

have a look at http://www.cpearson.com/excel/TimeZo...lightTime.aspx

**jwlamb** · 10-07-2013, 03:06 AM

I used a similiar page with the code, however it must be added into a module. Something else new to me. BUT, I did get it working.

Thank you all!

Originally Posted by patel45

have a look at http://www.cpearson.com/excel/TimeZo...lightTime.aspx

Prepopulated inputbox with current fiscal year, month, day

LinkBack

Thread Tools

Rate This Thread

Display

Prepopulated inputbox with current fiscal year, month, day

Re: Prepopulated inputbox with current fiscal year, month, day

Re: Prepopulated inputbox with current fiscal year, month, day

Re: Prepopulated inputbox with current fiscal year, month, day

Re: Prepopulated inputbox with current fiscal year, month, day

Re: Prepopulated inputbox with current fiscal year, month, day

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Chart titles that update with current fiscal year

how to convert date to fiscal year if fiscal year start at 16th or 17th of July

[SOLVED] Create Fiscal Year - Lookup Date in Fiscal Month Date Range and Return EOM Date

autocalculate current week of fiscal year?

[SOLVED] Pivot: Replace month numbers with month names and sort by fiscal year

Bookmarks

Bookmarks

Posting Permissions