Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Have today date appear automatically on the a column when using this macro

Posted on 2016-09-24
12
34 Views
Last Modified: 2016-09-25
How can i get the date to appear on the first column of the row when using this macro.

'copy the data to the database
        ws.Cells(iRow, 1).Value =
        ws.Cells(iRow, 3).Value = "          " & Me.textbox_name.Value
        ws.Cells(iRow, 4).Value = Me.Label4.Caption
        ws.Cells(iRow, 5).Value = Me.Label3.Caption
        ws.Cells(iRow, 6).Value = Me.Label5.Caption
        ws.Cells(iRow, 7).Value = "2"
0
Comment
Question by:Omar Hernandez
  • 5
  • 4
  • 3
12 Comments
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41813631
ws.Cells(iRow, 1).Value =Date

Open in new window

0
 

Author Comment

by:Omar Hernandez
ID: 41813633
Hey Roy Cox, it works wanted to know if there is a way to change the way it looks (9/24/2016) to this (9/24/16)
0
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41813641
Change the Format

ws.Cells(iRow, 1).Value =Format(Date,"mm/dd/yy")

Open in new window

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Omar Hernandez
ID: 41813642
It keeps showing the format as "mm/dd/yyyy"
0
 
LVL 18

Accepted Solution

by:
Roy_Cox earned 500 total points
ID: 41813655
Try

ws.Cells(iRow, 1).Value =Format(Date,"mm/dd/yy")
ws.Cells(iRow, 1).NumberFormat="mm/dd/yy")

Open in new window


Are the cells pre-formatted to "mm/dd/yyyy"
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41813669
Maybe this?
ws.Cells(iRow, 1).NumberFormat = "m/d/yy"
ws.Cells(iRow, 1).Value = Format(Date, "m/d/yy")

Open in new window

0
 

Author Comment

by:Omar Hernandez
ID: 41813975
Thank's again Neeraj the last suggestion that you have provided, works phenomenal. I have a pop up calendar function that when i click on cells it automatically pops up.

In order for that the pop up calendar to appear i would need to
1. Right click on the cell where i want the calendar to pop up.
2. On the number column of the box i need to click then on date.
3. Type of date 3/14/12

***Any way i can implement so that it can record this function on the macro.
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41814026
You're question is not clear to me.
As you said, you already have a code to input a date through the calendar pop up in a cell and I assume that works for you. So do you want to apply the same number format to that date cell or what?

It would be helpful if you can upload a sample workbook so that it would be easy to visualize your requirement more clearly.
0
 

Author Closing Comment

by:Omar Hernandez
ID: 41814060
Thanks Roy Cox this worked great
0
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41814349
Pleased to help.
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41814453
:)
0
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41814614
Having seen the mention of your calendar then the formatting should be done within the calendar form.

See my example workbook
Calendar-Forms.xlsm
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel TimeLine stopped working? 36 60
How to change the format as number 18 30
SKip past fields with no data 6 13
simple excel formula 4 13
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

840 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