-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ddate
-
N
Entering date as "DD/MM/YYYY@;" but result is with "DD-MM-YYYY"
Hello Trying to enter Date as .NumberFormat = "dd/mm/yyyy;@" but result displays as "dd-mm-yyyy" Dont understand why below for the reference Code in thisWorkbook Option Explicit Private Sub Workbook_Open() Dim ws As Worksheet Set ws = Worksheets("Sheet2") ws.Range("A:A").NumberFormat =...- NimishK
- Thread
- date dd/mm/yyyy;@ ddate dim end
- Replies: 13
- Forum: Excel Questions
-
R
VBA fast way to delete rows in a 2-column range if the date is less than a defined date
Hello everyone, I've defined a "Ddate" as being "Now()+14" I have a set of data on "Temp" sheet which has 2 columns. A is string and B is a list of dates. What I need to do is quickly run down these ~3,000 rows and delete any row where the value in B is less than or equal to "Ddate" I've...- RockandGrohl
- Thread
- date ddate defined delete rows
- Replies: 5
- Forum: Excel Questions
-
S
Force Date Format for a User Form
Hi folks, I have inherited an evaluation form and have a couple of improvements I want to do to it. There are 2 date fields on the form, Session Date and DOB. There is no formatting control on this so I want to force the date entered to be formatted correctly and throw a message box up if...- scotball
- Thread
- date dd/mm/yyyy ddate form textbox1.value
- Replies: 6
- Forum: Excel Questions
