playing

Sub TestVoices() Dim i As Long Dim voc As SpeechLib.SpVoice Set voc = New SpVoice i = [RANDBETWEEN(0,2)] Set voc.Voice = voc.GetVoices.Item(i) voc.Speak "I want to run next lines while voice is playing" MsgBox i End Sub In other versions I could do that , like this: Application...

Is there any way to use a Variable instead of "ActiveCell" in the following line: If Not Intersect(ActiveCell, ActiveSheet.ListObjects(CatTable).HeaderRowRange) Is Nothing Then I'm trying to tidy my code up and not use Select so playing around at the moment.

hello im looking for a fixture creator for playing on the season 4 to 5 time each teams and we are playing against 2 teams each tuesday the number of team can also change from 12 to 14 can anyone help me ? Regards

Hi, i'm new to this forum so i hope i've posted this in the right section. What i'm doing is making a spreadsheet for my Football Manager game. I've got everything i need in, i just need to get a formula right to make my "Match Squad" work properly. Each position i've done with all the correct...

Hi All trying to get this formula to work but it is just not playing ball =IF(OR(R24="Internal"),IF(Y24<1,"N/A",IF(Y24<$U$3,"Too Low",IF(Y24>$W$3,"Too High",IF(AND(Y24>$U$3,Y24<$W$3),"OK",IF(OR(R24="External"),IF(Y24<1,"N/A",IF(Y24<$U$8,"To Low",IF(Y24>$W$8,"To...

Hi, I am looking to add one more If to the following formula =IFERROR(IF('Order Information'!AW16="","",IF('Order Information'!B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<'Order Information'!B16,"Partially...