Good Morning,
I have created a userform that simply adds data to a sheet. It all works perfectly well, checks there is no blanks etc and I am pretty happy with it.
However one of my users wants something a bit more clever...
- To partially complete the form and save it to return to it later
- look at previous entries in the userform
Are these things reasonably easy to code? I am still a bit of a newb at this sort of thing.
Thanks in advance
Robin
As long as you don't Unload a userform using Hide instead all entered values remain in the form.
On point 2 you need to elaborate a bit more as of what you would like to achieve.
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.
Hi Bakerman
Hmm okay I will look into that. But I assume if you close and save the excel sheet then the temporary data gets deleted?
So if a user adds a row of data via a user form can they review that row using the userform?
Thanks
1. Indeed, as soon as you close the file all is lost.
2. If each row has some sort of unique identifier on which can be searched then Yes, no problem.
Or if it's always the last entered bottom row that has to be displayed that's even easier.
1. Hmm I think that is going to go to cause more issues than it would solve.
2. I have a unique Identifier on each row. Is there a code out there to look for them. I guess I can't guarantee it is always the bottom row.
There's code out there but it's specific for each userform so you best post an example file with your userform and some desensitized data to work with.
Otherwise it's going to become a back and forth story that has no ending.
thanks man will jiggle it around and post it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks