👉 Live recording will be available here within 1 Hour
All Prompts related to above video
#Prompt 1 : Create Index Sheet
I have multiple worksheets in an Excel workbook and want to create an index sheet listing all the sheet names. Write a VBA code that:
- Automatically generates a new sheet named ‘Index Sheet’ when I run the code for the first time.
- In the ‘Index Sheet’, cell A1 should contain the title ‘Serial Number’ and cell B1 should contain the title ‘Sheet Name’.
- Populates column A with serial numbers and column B with the corresponding sheet names.
- Each sheet name should be hyperlinked to its respective sheet.
- If the ‘Index Sheet’ already exists, running the code again should update it instead of creating a new one.”
#Prompt 2 : Create Index sheet Hyperlink
I have an Excel workbook with multiple worksheets and an ‘Index Sheet’ that lists all sheet names with hyperlinks. Now, I want to add a hyperlink to the ‘Index Sheet’ in cell A1 of every other worksheet.
Write a VBA code that:
- Adds a hyperlink to the ‘Index Sheet’ in cell A1 of every sheet except the ‘Index Sheet’ itself.
- The hyperlink should navigate to cell A1 of the ‘Index Sheet’.
- Running the code multiple times should update the hyperlinks if they already exist instead of creating duplicates.”
#Prompt 3 – Collect Duration of All .MP4 Files
“I have a folder on my computer that contains multiple .MP4 video files. I need a VBA code that:
- Opens a pop-up window to allow me to select the folder containing the .MP4 video files.
- Extracts the duration (length) of each .MP4 file from its properties.
- Creates a new sheet in the active workbook (or updates an existing one).
- Lists the .MP4 file names in Column A and their duration in Column B.
- Ensures that running the code multiple times updates the sheet instead of creating duplicates.”