Return date format in userform textbox

[kenjcd]

Good day everyone.

What I'm trying to achieve is, the textbox should be able to return date value instead string from another sheet2.
In sheet2 where the data is, I've set the respective cell as date.

Once I run the userform, and click a partiular value from the listbox, I'm getting string "64322" instead of "1/1/2021"

I've tried this, but no luck.

Please Login or Register  to view this content.

[Rick Rothstein]

I'm confused. You talk about setting a cell's format to Date on Sheet2 but then say you are clicking a value from a ListBox on the UserForm. Where is the value in TextBox12 coming from... a cell or a ListBox item? It would be useful if you could upload a copy of your workbook (desensitize any sensitive information) so we could see your layout, your UserForm's construction and the code you are using to process the data. To attach a copy of your workbook, you must follow the instructions in the yellow banner at the top of this forum's webpage.

[kenjcd]

Hi Rick,

Thank you so much for responding.
In textbox12, I'm getting 44460 instead of a date(value from Sheet2, E1)
Perhaps this workbook can help you better understand ya.
Sorry for the confusion.
Look forward to hear from you.

[torachan]

in your listbox event.

Please Login or Register  to view this content.

in your Refresh Sub

Please Login or Register  to view this content.

you were trying to read a value that did not exist in your listbox because you had not covered the total range.

You could save yourself 40 to 60 lines of code if you transferred data by looping through the textboxes to sheet cells

[kenjcd]

Thank you so much torachan.
I wish you well wherever you are!
Rep added, and again, thank you!

[torachan]

I have run through your code to demonstrate how little coding you need if using 'proper tables'.
Also in your particular app there is no need for a search routine - there is a direct link between the listindex and the table row.

[kenjcd]

This is way much better! The one that I have is bit buggy.
The direct link between the listindex and table row is VERY VERY helpful!
Gadzillion thanks torachan!

[kenjcd]

I have run through your code to demonstrate how little coding you need if using 'proper tables'.
Also in your particular app there is no need for a search routine - there is a direct link between the listindex and the table row.

Hi tora,

How do I link myForm to userform1?
Because I'm getting error, subcript out of range.
I've changed the table reference from table1 to table13

The commandbutton (Index) in myForm

Please Login or Register  to view this content.

Should be as simple as that right?
Where am I doing wrong?

[torachan]

your new 'Table13' is on Sheet4 not Sheet2

Please Login or Register  to view this content.

[kenjcd]

PERFECT!
Thank you.