Solved

VBA Command date.DTTo.Value = Date - 1

Posted on 2014-01-17
2
328 Views
Last Modified: 2014-01-17
I inherited a spreadsheet.

WHat does this mean in VBA?

date.DTTo.Value = Date - 1

DTTo is presumably some sort of variable ... but I can't determine what it is.


What about ?

Update.Show
0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 3

Accepted Solution

by:
Sreeram earned 500 total points
ID: 39790194
HI

  date.DTTo.Value = Date - 1

this line of code is refreing to a control

date - sheet name
DTTo-control name
Date- inbuilt funtion to get the system date

similar type of question has been answered in the below link:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28341196.html


update is an inbuilt function.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39790327
Thanks! ....
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associateā€¦
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question