Improve company productivity with a Business Account.Sign Up

x
?
Solved

VBA Command date.DTTo.Value = Date - 1

Posted on 2014-01-17
2
Medium Priority
?
335 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 2000 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

606 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