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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add days in date by macro
Try
Sub dd() tx = Sheets("Sheet1").TextBox1.Text With Sheets("Sheet2") ..Range("A7").Value = CDate(tx.Text) + 42 End With End Sub HTH Bob "K" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add days in date by macro
Hi,
When you get your 'date' from the textbox it's a srtring and you have to convert it to a date. Try this Sub dd() tx = Sheets("Sheet1").TextBox1.Value Stop With Sheets("Sheet2") ..Range("A7").Value = DateValue(tx) + 42 End With End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "K" wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add days in date by macro
Hmm,
And of course you don't need the STOP command I left in by mistake!! Sub dd() tx = Sheets("Sheet1").TextBox1.Value With Sheets("Sheet2") ..Range("A7").Value = DateValue(tx) + 42 End With End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike H" wrote: Hi, When you get your 'date' from the textbox it's a srtring and you have to convert it to a date. Try this Sub dd() tx = Sheets("Sheet1").TextBox1.Value Stop With Sheets("Sheet2") .Range("A7").Value = DateValue(tx) + 42 End With End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "K" wrote: 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add days in date by macro
On Feb 15, 11:30*am, Mike H wrote:
Hi, When you get your 'date' from the textbox it's a srtring and you have to convert it to a date. Try this Sub dd() tx = Sheets("Sheet1").TextBox1.Value Stop With Sheets("Sheet2") .Range("A7").Value = DateValue(tx) + 42 End With End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "K" wrote: 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 .- Hide quoted text - - Show quoted text - Thanks guys. it works now |
Reply |
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 |