video

So I have a question on the use of Environ function in VBA. If I want to open a file from my desktop, it appears I need to use forward slashes instead of backslashes? Is this correct? Is there a forward slash version on Environ? Private Sub PortConvey_Click() Dim sPath As String 'MTS...

I have 2 workbooks i want to pull data from and merge into one main page, I have followed the instructions per this Youtube video, but I am getting a 0 in over 50% of the fields that have a valid value. Video source: https://www.youtube.com/watch?v=yea2Zvb8Q7s Here is my formula...

Hi All, I found a video on youtube that draws bingo numbers with no repeats so I simply copied the Macro code by hand, the first part works and creates a random set of numbers the second part however is coming back with an error. This part works fine: Sub StartOver() Cells.Clear...

Hi all. I have the update form with a combobox that lists all names on spread sheet. Once one is selected it then populates the entire form with remain data in accordance with the name that was selected. Now, when I click on the update command button, I'm getting an error. I am watching this...

He goes over a little too fast for my newbie ears: I managed to adapt the formula to extract data from non adjacent COLUMN(S), but I don't understand the following: What part the AGGREGATE and SMALL functions play? Why he has to subtract the second ROW reference and divide? What the <>...

Hello all! Trying to use this macro (listed below) to copy rows (that include a certain word) to another sheet. As it is, it will only copy over the specified range of rows if the cell has "video" but id like it to copy it if it has "video" + any other comments that may be in the cell. Is that...

Hello EVeryone, I was wondering if there is anyway or Formula to extract Video id from youtube url . For example below is url https://www.youtube.com/watch?v=Hc7BjYmn9z0 and video id is Hc7BjYmn9z0 Is there any formula that I can use? Thanks in advance.

So I am looking to sort data on one specific sheet to other sheets by the date. I watch a video on it on youtube but it seemed to be a lot. This was the title of the video "Spreadsheets: How to Sort Data Onto Sub Sheets". I was hoping there might be a better way to do this or achieve this goal...

I am trying to control Powerpoint from Excel by following this video: https://www.wiseowl.co.uk/vba-macros/videos/vba-referencing-applications/powerpoint-presentations/ This is the code: Option Explicit Sub Start() Dim ppApp As PowerPoint.Application Dim ppPres As...

Hello All. I really would love to be able to change the default formatting for excel 2016 comments. IE the background colour and font (from bold to regular) etc. I found a video on youtube that shows how this is done on windows 7, but I can't seem to work this out for windows 10 (64bit) Thie...

I am looking to create a drop down navigation menu in Excel, and found this Youtube video that is very close to doing what I want it to do. The only thing that I want to change from the solution in this video is that it doesn't require a Go button. I want the user to simply be able to choose...

Im posting this video to better explain what Im looking for, for a CF formula, I hope someone can help me with it ? Thank you. Serge. https://youtu.be/joJU_nQyNNI

My question is rather complicated to explain via typing it out. If I could do a bit of show-and-tell then the answer I receive will likely I be more accurate and result in less back-and-forth trying to clarify things. So it is in that spirit that I took the time to create a short video that does...

https://www.betexplorer.com/soccer/scotland/championship/ayr-morton/EXyx7gQB/#1x2 DoEvents bookmakerFound = False Set tRows = HTMLdoc.getElementsByTagName("TR") For Each tRow In tRows If tRow.getElementsByTagName("TABLE").Length = 0 Then...

Hi I want to learn how to copy and paste a cell in vba. First, I thought it is as easy as Cells(1,1).copy cells(2,2).paste That would copy cells(1,1) and paste it into cells(2,2) but that did not work. It leads me to a question on why I have cell.paste function? So I went to watch a video and...

Hi I followed a video on how to put a pic in a UserForm. A combobox has (dog,cat, car) as a list and if user select cat, a pic of cat will appear in the from. I did exactly and it is working. But the code I did not understand is this Private Sub ComboBox1_Change() Image1.Picture =...

I tried to write an explanation of what I'm trying to accomplish in Excel, but can't find a way to explain it clearly, so I recorded a short screen video of my example sheet with explanation. I'd appreciate any help. Here's the explanation/question video link. Thank you!

Private Sub cmdbtnSearch_click() Dim totRows As Long, i As Long totRows = Worksheets("Sheet5(Slat)").Range("C3").CurrentRegion.Rows.Count For i = 3 To totRows If Trim(Sheet5.Cells(i, 3)) = Trim(TextBox1.Text) Then TextBox1.Text =...

Hello people Just been having a Google re adding text and a formula to a shape and found nothing that suggests that this is possible. But I'm sure I saw a video on just this thing a few months back. Annoyingly I cant find that video now - so maybe it was a dream. If someone could confirm if...

<colgroup><col><col></colgroup><tbody> Hi Everyone, Although I have used Excel to produce simple spread sheets, I am new to using VBA and macros. I am struggling with creating a macro that will do a fairly simple task and I have found a YouTube video that seems to do what I want but having...