JasonEnsor
Programmer
Hi,
I am using a userform built in Excel to populate a spreadsheet, which works fantastically (even if i do say so myself), however i have a slight problem with amending the data.
The userform contains several comboboxes with a set of possible choices, these choices relate to a customers payment (P - Paid, H- Holiday, PH - Paid Holiday etc..) depending on what the user selects determines what action is taken by the spreadsheet, for example PH would insert a date for a holiday which it gets from a label control on the userform in to a holiday list. This happens on the Change Event of the combobox which worked great until i needed to start amending the data.
My initial thought when trying to amend the data was to read the values from the spreadsheet and repopulate the comboboxes, however this now fires off the Change Event and would add the holiday again etc... I am using Comboboxes as it restricts the user to only be able to select the list of possible values i provide. There are 5 Comboboxes which depending on the situation of a users account can have up to 6 possible notations that can be used, so checkboxes are not a viable option.
Does anyone have anythoughts on what i could do? I am trying to not go down the route of having a special form for editing and updating user details as sometimes we might get payment for only 3 out of 5 weeks then the following week get the following 2 weeks paid for.
Any thoughts would be appreciated. I can explain anything in more detail if needed
Regards
Jason
I am using a userform built in Excel to populate a spreadsheet, which works fantastically (even if i do say so myself), however i have a slight problem with amending the data.
The userform contains several comboboxes with a set of possible choices, these choices relate to a customers payment (P - Paid, H- Holiday, PH - Paid Holiday etc..) depending on what the user selects determines what action is taken by the spreadsheet, for example PH would insert a date for a holiday which it gets from a label control on the userform in to a holiday list. This happens on the Change Event of the combobox which worked great until i needed to start amending the data.
My initial thought when trying to amend the data was to read the values from the spreadsheet and repopulate the comboboxes, however this now fires off the Change Event and would add the holiday again etc... I am using Comboboxes as it restricts the user to only be able to select the list of possible values i provide. There are 5 Comboboxes which depending on the situation of a users account can have up to 6 possible notations that can be used, so checkboxes are not a viable option.
Does anyone have anythoughts on what i could do? I am trying to not go down the route of having a special form for editing and updating user details as sometimes we might get payment for only 3 out of 5 weeks then the following week get the following 2 weeks paid for.
Any thoughts would be appreciated. I can explain anything in more detail if needed
Regards
Jason
