Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

populat days of month

I would like to populate the days ot the month to the right of l5 based on user input.the most efficient and quicket way.
thankss
Book1dates.xlsm
0
Svgmassive
Asked:
Svgmassive
2 Solutions
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Please find attached.
Book1dates.xlsm
0
 
SvgmassiveAuthor Commented:
can we also do in vba.thanks
0
 
Glenn RayExcel VBA DeveloperCommented:
Add this code to the Sheet object in VBA:
Option Explicit
Dim c As Integer
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$L$5" Then 'show dates for month
        For c = 0 To 30
            If Month(Target.Value + c) = Month(Target.Value) Then
                Target.Offset(0, c + 1).Value = Target.Value + c
            Else
                Target.Offset(0, c + 1).Value = ""
            End If
        Next c
    End If
End Sub

Open in new window


It will populate the cells to the right, starting with the data specified in cell L5, to the last day of the month.  It does not check that the date in L5 is ACTUALLY the first date of the month.

Example file attached.

-Glenn
EE-Book1dates.xlsm
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now