Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
last year i made a calendar and i manual inputted all the days. i have been
trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
Why don't you try one of the many free templates that are available.
Try below for a start http://office.microsoft.com/en-us/te...425251033.aspx "kimberlynn" wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
select the cell with the date range as you have shown and run this macro:
Sub AddDates() Dim s As String, s1 As String Dim s2 As String, i As Long Dim dt As Date, iloc As Long s = ActiveCell.Value iloc = InStr(1, s, "-", vbTextCompare) If iloc = 0 Then Exit Sub s1 = Trim(Left(s, iloc - 1)) s2 = Trim(Right(s, Len(s) - iloc)) i = 1 Debug.Print s1, s2 For dt = CDate(s1) To CDate(s2) ActiveCell.Offset(i, 0) = dt i = i + 1 Next End Sub -- Regards, Tom Ogilvy "kimberlynn" wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
macro?
"Tom Ogilvy" wrote: select the cell with the date range as you have shown and run this macro: Sub AddDates() Dim s As String, s1 As String Dim s2 As String, i As Long Dim dt As Date, iloc As Long s = ActiveCell.Value iloc = InStr(1, s, "-", vbTextCompare) If iloc = 0 Then Exit Sub s1 = Trim(Left(s, iloc - 1)) s2 = Trim(Right(s, Len(s) - iloc)) i = 1 Debug.Print s1, s2 For dt = CDate(s1) To CDate(s2) ActiveCell.Offset(i, 0) = dt i = i + 1 Next End Sub -- Regards, Tom Ogilvy "kimberlynn" wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
No, there is no built in capability to do what you ask.
If you don't want a programming solution, then post in microsoft.public.excel.misc or microsoft.public.excel.Worksheet.Functions from Excel help on Macros: About macros If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps. Recording macros When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands. If you make a mistake when you record the macro, corrections you make are also recorded. Visual Basic stores each macro in a new module attached to a workbook. Making a macro easy to run You can run a macro by choosing it from a list in the Macro dialog box. To make a macro run whenever you click a particular button or press a particular key combination, you can assign the macro to a toolbar button, a keyboard shortcut, or a graphic object on a worksheet. Managing your macros After you record a macro, you can view the macro code with the Visual Basic Editor to correct errors or change what the macro does. For example, if you wanted the text-wrapping macro to also make the text bold, you could record another macro to make a cell bold and then copy the instructions from that macro to the text-wrapping macro. The Visual Basic Editor is a program designed to make writing and editing macro code easy for beginners, and provides plenty of online Help. You don't have to learn how to program or use the Visual Basic language to make simple changes to your macros. With the Visual Basic Editor, you can edit macros, copy macros from one module to another, copy macros between different workbooks, rename the modules that store the macros, or rename the macros. Macro security Excel provides safeguards that help protect against viruses that can be transmitted by macros. If you share macros with others, you can certify them with a digital signature so that other users can verify that they are from a trustworthy source. Whenever you open a workbook that contains macros, you can verify their source before you enable them. -- Regards, Tom Ogilvy "kimberlynn" wrote: macro? "Tom Ogilvy" wrote: select the cell with the date range as you have shown and run this macro: Sub AddDates() Dim s As String, s1 As String Dim s2 As String, i As Long Dim dt As Date, iloc As Long s = ActiveCell.Value iloc = InStr(1, s, "-", vbTextCompare) If iloc = 0 Then Exit Sub s1 = Trim(Left(s, iloc - 1)) s2 = Trim(Right(s, Len(s) - iloc)) i = 1 Debug.Print s1, s2 For dt = CDate(s1) To CDate(s2) ActiveCell.Offset(i, 0) = dt i = i + 1 Next End Sub -- Regards, Tom Ogilvy "kimberlynn" wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
oh i just didn't know what micro was. i'm not all that knownledgable with
excel i am still fairly new to it. thank you for the help. "Tom Ogilvy" wrote: No, there is no built in capability to do what you ask. If you don't want a programming solution, then post in microsoft.public.excel.misc or microsoft.public.excel.Worksheet.Functions from Excel help on Macros: About macros If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps. Recording macros When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands. If you make a mistake when you record the macro, corrections you make are also recorded. Visual Basic stores each macro in a new module attached to a workbook. Making a macro easy to run You can run a macro by choosing it from a list in the Macro dialog box. To make a macro run whenever you click a particular button or press a particular key combination, you can assign the macro to a toolbar button, a keyboard shortcut, or a graphic object on a worksheet. Managing your macros After you record a macro, you can view the macro code with the Visual Basic Editor to correct errors or change what the macro does. For example, if you wanted the text-wrapping macro to also make the text bold, you could record another macro to make a cell bold and then copy the instructions from that macro to the text-wrapping macro. The Visual Basic Editor is a program designed to make writing and editing macro code easy for beginners, and provides plenty of online Help. You don't have to learn how to program or use the Visual Basic language to make simple changes to your macros. With the Visual Basic Editor, you can edit macros, copy macros from one module to another, copy macros between different workbooks, rename the modules that store the macros, or rename the macros. Macro security Excel provides safeguards that help protect against viruses that can be transmitted by macros. If you share macros with others, you can certify them with a digital signature so that other users can verify that they are from a trustworthy source. Whenever you open a workbook that contains macros, you can verify their source before you enable them. -- Regards, Tom Ogilvy "kimberlynn" wrote: macro? "Tom Ogilvy" wrote: select the cell with the date range as you have shown and run this macro: Sub AddDates() Dim s As String, s1 As String Dim s2 As String, i As Long Dim dt As Date, iloc As Long s = ActiveCell.Value iloc = InStr(1, s, "-", vbTextCompare) If iloc = 0 Then Exit Sub s1 = Trim(Left(s, iloc - 1)) s2 = Trim(Right(s, Len(s) - iloc)) i = 1 Debug.Print s1, s2 For dt = CDate(s1) To CDate(s2) ActiveCell.Offset(i, 0) = dt i = i + 1 Next End Sub -- Regards, Tom Ogilvy "kimberlynn" wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar help
Hi, I am using a calender in excel. I just input the year, and calender is formed according to the days in weeks. I can input any year. Sharad On Feb 2, 10:16 pm, kimberlynn wrote: last year i made a calendar and i manual inputted all the days. i have been trying to figure out how have the auto fill in. what i did was put the weekly dates in like this... in one block 02/01/2006 - 02/04/2006 then below that i manual put in the dates like this... 02/01/2006 02/02/2006 what i was wondering is there a way that when i insert the weekly dates that block automaticaly fills in the date blocks below? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |