play

Hi All, I am having trouble getting this to work. I am close, but probably missing something. I am trying to play a wav file when the active cell is U18. When the user selects this cell, I want the audio file to play. When I use the code below, it works when I have the cell selected and run the...

Hi Members I am trying to create a spreadsheet for our tennis club, We may have members that play on multiple teams , on our calendar to schedule matches I would like to be able to restrict the drop downs if a player team is selected then any other team that they play on can not be selected...

Hello, can someone please help with this... I'm trying to get excel to IF function to return to words to W and L without having to manually type it in. Here is an example below. The forecast means, +16 play the over to win and -11 means play the under to win. basically any plus symbol play over...

I'm trying to create a spreadsheet where I can 20 golfers playing over 3 days and none of the golfers play with each other twice. On each team will be two "A" players and two "B" players. I've figured out how to make the 1st day random but I can't figure out out to make days 2 & 3 where the...

I help run a small pool league. We have about 30 teams. I would like to generate a spreadsheet to assist with team scheduling. We are given a schedule from teh league with teams $'s that tell us for teh session who plays who on what week. But we need to figure out the game tables for them...

Hello all! I've got a small spreadsheet to keep track of the decks I have for a trading card game, and how many wins they have when played against my other decks. I play three rounds each against each combination of decks. The sheet is laid out such that both the first row and first column...

Hi Fluff/Everyone, HNY! :smile: https://1drv.ms/x/s!Aszg_mMOoSFEgRyt-qUa9uRsOkZG Could you have a look at my spreadsheet and tell me if there is a way of keeping the formulas in the same order as the rest of the data after sorting it using the buttons? I had a play with changing the...

<tbody> </tbody> Hi all, https://imgur.com/a/X0sW0kE Would anyone know a formula which sums all oranges in january, but only if the value of the cell is at most 10? So in the attached example it would come to 19. I have had a play with the SUMPRODUCT formula but can't get this to...

Hello, I have a code that works perfectly every time when I step through it, however when I play it normally it does not. It will save a white image rather than the range. This code saves a range as a .PNG. It took me forever to find one that worked the way I want it to. What I like about this...

Hi everyone, (New here so go easy on me please). I need to create a fixture list (home and away) that can adjust to different number of players but there's one difficult part: we need everyone to have as many home games (or away games) in a row if possible and all teams must play at the same...

hi, can you please help me to understand this issue and correct it? i´ve addapted code to play sounds and it works fine if the mp3 file is placed at C:\Users\Bruno Andrade\Music\ Sub M_02SomNiv2() Dim play As String play = """C:\Users\Bruno Andrade\Music\som02-Niv2.mp3""" Shell...

Is it Posible to play a Mp3 File on given value Your Regards from Hjemmet

Can someone send me a simple Excel spreadsheet that will play a sound wav file. I have read a lot of posts and still could not understand how to do it. I just need a simple Excel spread sheet that will play a "correct" sound file when cell a1 = b1. Is it OK to post my email address in this...

So, I am working with a sheet that has a certain number in each column KL-LM, only if the number in JX is different from the one in the row above. So JX3 is 1850, that means KL to LM will have this number times a factor. In JX43 there is 1450. Now as you can see in the screenshot, KF3 is 6607...

Good Day All I need Macro to Play Sound File format m4a from Excel 64 Bit Thanks

Hello People, Would someone be kind enough to give me a VBA code that will play an MP4 video when I click a button. Not sure if it's possible, though. Thanks in advance

Hi, everybody! I would like to request some assistance for the following: each weekend me and a group of friends play a football match, and we always have trouble when making the starting lineups, so I want to create a formula or a macro that can create random, balanced teams based on the...

Hello, I have some trouble solving the following exercise: In column M on the worksheet ‘Purchase Invoices’ use an appropriate lookup function based on thedescription, together with an appropriate logical formula to show whether the supplier for eachinvoice is on the approved supplier list. The...

Good morning I am running a dart league here are the details 12 teams (Team1, Team2, Team3...etc) 2 Division (odd teams and Even Teams) 16 weeks 6 Boards (all teams play at the same time) I would like the teams to play in the same division 2 times, while playing the opposite division 1 time...

I am using sndPlaySound32 to play wav sounds in Excel. But I can´t play some of my wav files and I have been unable to figure out why. The only special about the files that I cannot play is they are 10 kbps files (it is speech recordings) and not 128 as the other files. Do anyone know of a...