Hi,
I prepare Daily sales report for my organization and I made a macro for it and it does almost 70% of my work. In that macro we add this option where it ask us the date we need our report for and it goes like this in macro,
Date_value = Application.InputBox(prompt:="last working day(DDmmyy)", Type:=2)
In this window i have to put date manually and in specified format, i was wondering if there is any option in macro that this pop up window will give you a drop down option of last 5 days and instead of typing date you just have to choose one.
Thanks
Chicky
I prepare Daily sales report for my organization and I made a macro for it and it does almost 70% of my work. In that macro we add this option where it ask us the date we need our report for and it goes like this in macro,
Date_value = Application.InputBox(prompt:="last working day(DDmmyy)", Type:=2)
In this window i have to put date manually and in specified format, i was wondering if there is any option in macro that this pop up window will give you a drop down option of last 5 days and instead of typing date you just have to choose one.
Thanks
Chicky