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
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