Hi,
I am having some issues with getting some code working in Excel. I am trying create a sheet which tracks staff holidays and which allows entries to be recalled readily and edited/deleted.
I have created a userform which contains a couple of buttons, a listbox and combobox. I want the list box to be populated by the data on the sheet (which will grow with time) and to be filterable using the combobox. The combobox will be populated by the entries in column A of the sheet. The idea is that a manager can load up (filter) the entries for a staff member (within the userform) and then edit/delete as required.
I did have this working for a short period but now am completely stuck. I will try to attach the sheet and code that I have so far. I am not a VBA expert and, for the most part, my code is adapted from that which I find on the internet. This has always worked well but this time I find my self going round in circles and have been for about a week.
Any help or comments that you can provide to get me back on track would be much appreciated.
Steve
I am having some issues with getting some code working in Excel. I am trying create a sheet which tracks staff holidays and which allows entries to be recalled readily and edited/deleted.
I have created a userform which contains a couple of buttons, a listbox and combobox. I want the list box to be populated by the data on the sheet (which will grow with time) and to be filterable using the combobox. The combobox will be populated by the entries in column A of the sheet. The idea is that a manager can load up (filter) the entries for a staff member (within the userform) and then edit/delete as required.
I did have this working for a short period but now am completely stuck. I will try to attach the sheet and code that I have so far. I am not a VBA expert and, for the most part, my code is adapted from that which I find on the internet. This has always worked well but this time I find my self going round in circles and have been for about a week.
Any help or comments that you can provide to get me back on track would be much appreciated.
Steve
