Good morning
I am working on a form to input 4hourly data and i need it to have three sections pre populated with the last ones focus. Can i write some code to tell the three Txt boxes to get the information from the last cell entry? then all we have to do is select the yes no button to say if they have been completed?
This is the code i have to open the form which is where i am asuming i will have to put the code to pre fill the Txt boxes.
Please Login or Register to view this content.
You'll have to store the value of the controls somewhere before closing the userform; to a sheet, to a text file, or to the built-in property fields, such as Author, subject, etc.
Then when you reopen the form, reset the values to the controls.
David
(*) Reputation points appreciated.
Put the code in the userform's Initialize event.
You don't say where the data will come from so here's a simple example that fills three textboxes with the last values from columns A, B and C on Sheet1.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Ok sorry some more information.
The 3 texted boxes are named Txt_LastFocus1, Txt_LastFocus2 and Txt_LastFocus3 the data is located in "Data" sheet columns R,T and V
Try this.
Please Login or Register to view this content.
Originally Posted by Norie
Try this.
Please Login or Register to view this content.
I get an error saying invalid use of Me Keyword
Did you put the code in the userform module ?
This also works.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Where is the userform module i put it in the open form moduleDid you put the code in the userform module ?
This also works.
Please Login or Register to view this content.
Have a read, it's something you're going to have to understand.
Thanks for the help i will read up now. its a step learning curve
i have uploaded a copy of my WB as i am now getting an error code. I have put the code to populate the Focus in the Form but i am now getting an error when i try to open the form using the button on Sheet 1 (Data)
You don't have a worksheet with the Tab name 'Sheet1'.Please Login or Register to view this content.
The syntaxis referring to a sheet Tab name. As this can easily be changed by the user it's not considered 'good code' - as soon as the tab is renamed the code will error.Please Login or Register to view this content.
Much safer to refer to worksheets using the Code Name as this can only be changed in the VBA dev environment - you should change the code to
You now need to add this to your reading list. In fact, a general browse around that site would probably be the best thing you do today (Code wise), starting with this to really get off to a flying start with VBAPlease Login or Register to view this content.
Last edited by cytop; 06-18-2017 at 08:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks