PDA

View Full Version : VBA Textbox get last entry from time stamp



sswcharlie
04-08-2018, 01:58 PM
Hi
Excel 2016 Insert Textbox

With a text box that each time an entry made (using append data), it has:

Identification Number (from macro)
Text (user input)
Time only stamp ( from macro)(last item in set of data)

This info sent each time to another textbox Old data retained in textbox. Cleared once a day.

I am making a macro to select data from last time stamp +1 (that is the new data)

Just need: The line for referring back to the last time set and selecting data up to latest timestamp, how do I state to this?

To clear the textbox there is .text"" etc or is there a better option?

thanks

Charles Harris

SamT
04-08-2018, 03:09 PM
I think that we'll need to see a sample workbook, there isn't enough information in your post.

PLease.... DON'T post screenshots.

Use the Go Advanced button and on that page, at the bottom, use the Manage Attachments button to upload the workbook