Create an Excel Macro from Scratch: AutoFit Columns
video description
Date: 2022-04-08
Related videos
Comments and reviews: 7
Enkhtur
Hi, I have the following problem: I'm running MS Office Professional Plus 2019 and have created a folder on my desktop. Inside this folder, I have created two seperate MS Excel workbooks - one containing text while the other contains screenshots or images that correspond to some of text in the other workbook. In the workbook containing text, I have created links to images that I have put in the other workbook. The idea is to read text and see corresponding images with a click of a button. Now the problem start to arise whenever I 1). add additional columns in the workbook that contain images or 2). re-locate the folder containing these two workbooks. I wonder if there is any way around this problem?
reply
Hi, I have the following problem: I'm running MS Office Professional Plus 2019 and have created a folder on my desktop. Inside this folder, I have created two seperate MS Excel workbooks - one containing text while the other contains screenshots or images that correspond to some of text in the other workbook. In the workbook containing text, I have created links to images that I have put in the other workbook. The idea is to read text and see corresponding images with a click of a button. Now the problem start to arise whenever I 1). add additional columns in the workbook that contain images or 2). re-locate the folder containing these two workbooks. I wonder if there is any way around this problem?
reply
Jennie
yes please to more VBA codes or other Excel macros. It would be great to show us an example where, say, one sheet you have a list of pupils name down the row, and list of subjects across the column, and on another sheet, you either type in or select pupils name in one cell and select or type in subject in a second cell, and then in third cell type in their grade or comments and these grades and comments can auto-populate to the right cell in the first sheet.
reply
yes please to more VBA codes or other Excel macros. It would be great to show us an example where, say, one sheet you have a list of pupils name down the row, and list of subjects across the column, and on another sheet, you either type in or select pupils name in one cell and select or type in subject in a second cell, and then in third cell type in their grade or comments and these grades and comments can auto-populate to the right cell in the first sheet.
reply
derekcanmexit
I am starting to delve in the world of VBA so these type of beginner videos are an excellent start for me. As I understand, when you first create a macro, it works only in that particular workbook. But what if you want to use the macro in other workbooks? I am sure there is a way to do so - and I will need to investigate further. Thanks again for this video!
reply
I am starting to delve in the world of VBA so these type of beginner videos are an excellent start for me. As I understand, when you first create a macro, it works only in that particular workbook. But what if you want to use the macro in other workbooks? I am sure there is a way to do so - and I will need to investigate further. Thanks again for this video!
reply
28urmi
Would you please create a video to delete columns some conservative while others not, to exclude erroneous columns to run a macro and then sort by date and the name - say colomn 3 then colomn 2. ?? Need some help. Thanks!
reply
Would you please create a video to delete columns some conservative while others not, to exclude erroneous columns to run a macro and then sort by date and the name - say colomn 3 then colomn 2. ?? Need some help. Thanks!
reply
Lor'
Thanks for explaining well. VBA wasn't my forte in creating macro so I use the macro recording button to create one and that works too. Wish I could review my VBA lessons again. Thanks for sharing. Cheers.!-
reply
Thanks for explaining well. VBA wasn't my forte in creating macro so I use the macro recording button to create one and that works too. Wish I could review my VBA lessons again. Thanks for sharing. Cheers.!-
reply
ola
Sir am looking for program make mental path for students ...in teams every last week I should make prife for lessons ... How can I make it
reply
Sir am looking for program make mental path for students ...in teams every last week I should make prife for lessons ... How can I make it
reply
Morm
after crating VBA for autofit,when I did the next step- developer-macros
it did not showed the title or any document to choose from
reply
after crating VBA for autofit,when I did the next step- developer-macros
it did not showed the title or any document to choose from
reply
Add a review, comment
Other channel videos
