scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi all,
this is my first post and I am currently an occasional user of excel - this is my first attempt at Excel VBA
My question to the forum is this:
I am using Excel 2007 and would like to create a fairly complex user form that is basically a daily operations report where each row=1 days report. The form works well and updates the excel sheet perfectly.
My problem is that my daily report uses up to 10 combo boxes that allow the input of team members. I would like for the user NOT to have to keep re-selecting these team members from the combo boxes as they do not change that often. When the form is opened, is there a way to get the combo boxes to default to the previous "days" team members so that they can be re-used into the current days report.
Is this at all possible?
Many thanks in advance
Scott
this is my first post and I am currently an occasional user of excel - this is my first attempt at Excel VBA
My question to the forum is this:
I am using Excel 2007 and would like to create a fairly complex user form that is basically a daily operations report where each row=1 days report. The form works well and updates the excel sheet perfectly.
My problem is that my daily report uses up to 10 combo boxes that allow the input of team members. I would like for the user NOT to have to keep re-selecting these team members from the combo boxes as they do not change that often. When the form is opened, is there a way to get the combo boxes to default to the previous "days" team members so that they can be re-used into the current days report.
Is this at all possible?
Many thanks in advance
Scott