Skip to content

Instantly share code, notes, and snippets.

@imamuddinwp

imamuddinwp/Excel VBA Macro: Dialogue Box to Input Data in run time

Created July 14, 2020 08:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save imamuddinwp/37e5c30581057d23838b8d9854ee6f53 to your computer and use it in GitHub Desktop.
Save imamuddinwp/37e5c30581057d23838b8d9854ee6f53 to your computer and use it in GitHub Desktop.
Download ZIP
Excel VBA Macro: Dialogue Box to Input Data in run time
Raw
Excel VBA Macro: Dialogue Box to Input Data in run time
Dim ConfDate As String
ConfDate = InputBox("Input Valid Date, Date Format Example: --> 25.04.2019 ", "ProudLy powered by : ImAmUdDiN ")
Range("G2").Value = ConfDate
' Date autofill by Flash Fill
Range("G2").FlashFill
Range("G2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FillDown
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment