Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill months in cell
I have a combobox in userform containing months like January,
February, March,so on. How do i write a code such that if the user select a particular month (say January) in the combobox, it will be written to cell A1, after which the program could autofill the months from cell A2 downwards, reflecting February, March, and so on.? Thanks:) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill months in cell
(Untested):
Dim i As Integer For i = 1 to 12 Range("A" & i) = CStr(Format(DateSerial(Year(Date), _ Month(DateValue("1-" & UserForm1.ComboBox1)) + i, 1), "mmmm")) Next i -- Vasant "paradise" wrote in message om... I have a combobox in userform containing months like January, February, March,so on. How do i write a code such that if the user select a particular month (say January) in the combobox, it will be written to cell A1, after which the program could autofill the months from cell A2 downwards, reflecting February, March, and so on.? Thanks:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill Months | Excel Discussion (Misc queries) | |||
AutoFill a cell with a value | Excel Discussion (Misc queries) | |||
Can autofill, as in months or dates, go to the end of the spreads | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
AutoFill Visible Cells with Months | New Users to Excel |