Playing specific WAV files with a command button using a combobox value

[Marc De Vlam]

Hello Forum, I would like to have a userform with a combobox and a commandbutton which would play a specific WAV file (= city name) depending on the city name selected in the combobox. I have a code which works fine assigned to a commandbutton on an excel sheet using the value of a specific cell :

Please Login or Register  to view this content.

However this is not feasible when 3000 city names are involved.

Does anyone know the right code/syntax to use the combobox value as a variable for the WAV file name, something like : (not working)

Please Login or Register  to view this content.

Thanks in advance

[buran]

Hi,

Please Login or Register  to view this content.

However it will not work if the wav name is not the same as the city name (combobox value), e.g. "Merksem (Antwerpen)". You need to parse the combobox1 value, but I'm not able to give any advise as I don't know all possibilities

[Marc De Vlam]

Hi Buran, thanks for yr quick reply. Code works fine now ! (the devil is in the detail as always )

Fyg wav names match with city names.

Rgds
Marc