let's try flv first:
https://www.dropbox.com/s/hgk18oltwj...tled5.flv?dl=0
and now mp4:
https://www.dropbox.com/s/gel0dg7xad...edia1.mp4?dl=0
let's see...
Well that only gave a link. I was hoping by putting the url within video tags it would be playable in situ.
You trying to play this in a userform?
Paul
------------------------------------------------------------------------------------------------------------------------
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
(multiple files can be selected while holding Ctrl key) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
No, just in a post in a regular thread: msg#7 in this thread: http://www.vbaexpress.com/forum/show...ox-on-userform
p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Trying XL2BB from MrExcel here:
[RANGE=cls:xl2bb-100][XR][XH=cs:5]xl2bb.xlam[/XH][/XR][XR][XH][/XH][XH=w:207.75]A[/XH][XH=w:107.25]B[/XH][XH=w:51]C[/XH][XH=w:164.25]D[/XH][/XR][XR][XH=ch:21]1[/XH][XD=fw:b|cls:bb][/XD][XD=fw:b][/XD][XD=fw:b][/XD][XD=h:l|fw:b|fz:16pt]7A-7P DAILY STAFFING[/XD][/XR][XR][XH=ch:18.75]2[/XH][XD=h:c|fw:b|fz:14pt|cls:bt bb]2 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]3 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]ED[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]FLOAT POOL[/XD][/XR][XR][XH=ch:18.75]3[/XH][XD=h:c|fw:b|bc:E2EFDA|fz:14pt|cls:bt]29/09/2019[/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][/XR][XR][XH=ch:15]4[/XH][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][/XR][XR][XH=ch:15]5[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]6[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]7[/XH][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:l][/XD][/XR][XR][XH=ch:15]8[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Joe[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN17[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]9[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jack[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN18[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]10[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jane[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN20[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]11[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN23[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]12[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]13[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]14[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]15[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]16[/XH][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b][/XD][XD=h:c|fw:b][/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Housewide[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][RANGE=cls:xl2bb-extra-100][XR][XH=cs:3]Cell Formulas[/XH][/XR][XR][XH]Range(s)[/XH][XH=cs:2]Formula[/XH][/XR][XR][XD]A8:A15[/XD][XD]A8[/XD][XD]{=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0,MATCH($ A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD]B8:B15[/XD][XD]B8[/XD][XD]{=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0,MATCH($ A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD=cs:3|p:5|fz:0.85em]Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.[/XD][/XR][/RANGE]
Last edited by p45cal; 12-23-2019 at 05:21 AM.
Well that failed!
I think you're out of luck to have a video play in situ
https://www.dropbox.com/s/hnzrl4wetq...32-18.mkv?dl=0
Advanced has the Insert Video icon, but all it really does is insert [ video ] .... url .... [ /video ] tags
[VIDEO]https://www.dropbox.com/s/hnzrl4wetqefmco/2019-12-17%2011-32-18.mkv?dl=0[/VIDEO]
Paul
------------------------------------------------------------------------------------------------------------------------
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
(multiple files can be selected while holding Ctrl key) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Reluctantly, that's the same conclusion I reached; I was hoping the play button and message would be in the vbax message and the video play without going to another site.
p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote
