View original (French)

Insert video and music + other

Rjp62 Posted messages 48 Registration date   Status Member Last intervention   -  
danielc0 Posted messages 2230 Registration date   Status Member Last intervention   -
Hello everyone,

I hope someone can help me.

Here is my problem: I’m working on a guitar songbook. I will attach images of the file as an appendix.

Starting from a dropdown menu that contains the titles of all the pieces, when selecting a title I would like it to open the lyrics of the song, the tablature, the audio of the song, as well as the video of the song and the tutorial for the song.

I have created a layout with dropdown menus for the songs, and buttons so that when I click them it displays next to or below the buttons what I described.

Thank you if you have a solution.

See you soon,
Rjp

3 answers

  1.
    Grandasse_ Posted messages 992 Registration date   Status Member Last intervention   618
     

    Hello,
    There is something I’m not sure I understand: do you want to solve this problem locally on your PC using a spreadsheet and macros, or are you thinking about hosting a site online?

    Otherwise: what are your questions? What have you started doing and where are you stuck?

    0
  2. Rjp62 Posted messages 48 Registration date   Status Member Last intervention   1
     

    Hello,

    Yes I want to solve the problem and locally in Excel.

    The dropdown menu of different groups of singers is done.

    I would like that when I click on a singer's title in the dropdown menu, the text opens in another window, as well as the tablature and rhythm of the song, then the video of the song and the tutorial of the piece, and also for the end the audio of the song. And every time I click on a button that I prepared a window opens. (see image in Annex)

    I'm not sure if I'm clear in my request !!!

    thank you.

    0
  3. danielc0 Posted messages 2230 Registration date   Status Member Last intervention   297
     

    Hello everyone,

    Assuming the files are local (or in the cloud), please post a zip with the workbook and test files.

    Daniel

    0