Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add days in date by macro
Hi all, I have TextBox1 on Sheet1 and in that TextBox1 I have date
like "15/02/2010". I made macro (see below) in which I tried to get a date in cell A7 of Sheet2 which should be the date of 42 days ahead of the date in TextBox1. My macro is not working and I am getting error saying "Run-time error '13': Type mismatch". Please can any friend help that what i am doing wrong. Sub dd() tx = Sheets("Sheet1").TextBox1.Value With Sheets("Sheet2") ..Range("A7").Value = tx + 42 End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS | Excel Programming | |||
Macro to highlight cells that are 5 business days from trade date | Excel Programming | |||
Macro to add 1 or more days to a date | Excel Programming |