
Active Member

September 16, 2019

Hi everyone,
First, I am new to this forum, but I hope I can finally find a solution to my problem. I will try to keep it short and to the point.
I am using Windows 8.1 (64 bit) and MS Excel 2016 (also 64 bit).
I am trying to automate an inventory spreadsheet by using a macro input form (userform). The major headache I have is the date picker function. I have spent numerous hours looking for a solution for a Date Picker. I downloaded the date picker xlsm file from the post "JULY 9, 2015 by Philip Treacy"
When I try to use it, I get a 438 run-time error "Object doesn't support this property or method"
I've reduced my worksheet and user form to 2 entries to test if it works; if I comment out the calendar frame line it works
With lastrow
' .Cells(1,1) = Frame1.Value
.Cells(1, 2) = BulkCode.Value
End With
I am not an experienced VBA user, but I use excel a lot to help the employees enter records.
I have attached the excel (xlsm) file and error msgs that I received. Any help from anyone would be fantastic.
Thank you





November 8, 2013

Hi Robert,
Should be >Frame1.Caption, not .Value
The .Value property an be used in textbox, combobox, checkbox, but in labels, frames, use .Caption.
But the Caption will return a null string, because the date is not in the Frame, it's the value of the calendar you need.
I's not an error in Date Picker, it's how you use the objects.
Use instead:
With lastrow
.Cells(1, 1) = Calendar1.Value
.Cells(1, 2) = BulkCode.Value
End With

Active Member

September 16, 2019

Catalin,
Thank you so much.
I have tried it out. It seems like the date value only appears when I double click on the day box in the calendar. Also, if my cursor is in another cell on the spreadsheet the date value shows up in that cell example, if my cursor was on D10, and I double click on the day (in the calendar), then the date will show up in cell D10. I want the date only to show up in the date column of the table.....is that possible?
Thank you again
Robert
1 Guest(s)
