JeremyA1976
Board Regular
- Joined
- Aug 3, 2015
- Messages
- 59
I have a userform named "BID_Information". This userform is used to input project name, drawing number, area and description to multiple sheets so it populates certain cells which then flow through a formula and produce bid information. I have all of this working great, but it becomes a nuisance to have to type all of that back in each time you start a different area or drawing.
Is there a way to populate this userform information to a hidden worksheet and then have the userform recall those cells when initiated? Kind of like a memory default from the last job that was bid.
This way only one or two text boxes would need to be changed.
I have a template set up so that I can open it, "save as" to a project file and begin the bid process, so I would imagine in order to keep the last one in memory, I would have to run a save command at the end of the submit button push, so it keeps revising the template file. I am sorry if I am not clear. I am very new to working with vba and not very talented at it.
Any help will be appreciated.
Is there a way to populate this userform information to a hidden worksheet and then have the userform recall those cells when initiated? Kind of like a memory default from the last job that was bid.
This way only one or two text boxes would need to be changed.
I have a template set up so that I can open it, "save as" to a project file and begin the bid process, so I would imagine in order to keep the last one in memory, I would have to run a save command at the end of the submit button push, so it keeps revising the template file. I am sorry if I am not clear. I am very new to working with vba and not very talented at it.
Any help will be appreciated.