How can I modify date format in Excel VBA, userform

Question

I have a UserForm that automatically populates with given data from a table, I cannot get the format of the date to change. I am not sure where my code went wrong.

Set name_ = Display.Controls.Add("Forms.Label.1", "Test" & labelCounter, True)
    With name_
        .Caption = Format(debt_name_cell, mmm - yy)
        .Left = 10
        .Width = 50
        .Top = 10 * labelCounter
    End With
    Set debt_name_cell = debt_name_cell.Offset(1, 0)

Graham · Accepted Answer · 2017-09-21 16:13:52Z

3

Having a look at the Microsoft VBA Reference is always a good idea:
Format Function (Visual Basic for Applications).

There we can see that the second parameter of the Format function has to be a string like

Format(debt_name_cell, "mmm - yy")

If you follow VBA Best Practices use Option Explicit at the top of every VBA module you would have recognized an issues like that in a second!

edited Sep 21, 2017 at 16:13

Graham

7,86020 gold badges67 silver badges92 bronze badges

answered Apr 21, 2017 at 12:09

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Rushton Over a year ago

If this answer helped you, please consider accepting it. Accepting an answer rewards the contributor for their time and helps others to find a workling solution.

Collectives™ on Stack Overflow

How can I modify date format in Excel VBA, userform

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related