Hi,
Im very new to VBA but have tried several different amalgamations of things I have read to get the following result without success. Any help would be greatly appreciated!
I'm trying to set up a macro, so that on clicking a command button on a user form; which enters the collected data into a spreadsheet; it also takes the month name and year from a date entered into a textbox on the userform and populates a listbox on another sheet with this month name and year, as long as this is not a duplicate.
For example: the user has entered "Sunday, 1 October 2017" into textbox1 on userform1.
On clicking commandbutton1, I want "Sunday, 1 October" to be put in Sheet 1, Cell A1. AND I want "October 2017" to be entered into ListBox1 on Sheet2, as long as listbox1 doesn't already contain this item.
Please help!!
Im very new to VBA but have tried several different amalgamations of things I have read to get the following result without success. Any help would be greatly appreciated!
I'm trying to set up a macro, so that on clicking a command button on a user form; which enters the collected data into a spreadsheet; it also takes the month name and year from a date entered into a textbox on the userform and populates a listbox on another sheet with this month name and year, as long as this is not a duplicate.
For example: the user has entered "Sunday, 1 October 2017" into textbox1 on userform1.
On clicking commandbutton1, I want "Sunday, 1 October" to be put in Sheet 1, Cell A1. AND I want "October 2017" to be entered into ListBox1 on Sheet2, as long as listbox1 doesn't already contain this item.
Please help!!
