Hi,
I hope I can get some help or guidance from someone here. I've uploaded a simplified sheet which I hope is easy to understand. I import the data and trim and format it using other code, the layout is not important to me as it is because the sheet will be hidden. I have noticed I'll need to unhide when using the userform though.
I am trying to create a userform using comboboxes to allow me to enter horse racing data to another sheet. I want to select a Track which in turn will populate the race times combobox for the selected track which in turn will populate the Names (horse names) combobox. I've managed to create the userform and it works to a point but somehow the Names combox gets populated twice resulting in a dropdown of duplicates. One other issue is the time format is wrong in the dropdown but shows the correct format in the combox once selected. Also is it possible for the Track combobox to be empty when userform is loaded until I make a selection and is there a way to disable any manual entries?
Any other advice or different methods on using multiple dependent comboboxes would be welcome
[ATTACH]n1207520[/ATTACH]