Thank you for your effort in explaining the lessons .... Please I want to make a macro using loop to make specific values in cells based on a specific number in a specific cell
Hello, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 8" or for x = 1 to whatever . What if I wanted to be able to change the " 8 " element (end point) from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. Any suggestions? Thank you
You can declare upper range as inputbox and every time macro is run, user have to enter that value. Dim i as variant i = inputbox("Please input value") x = 1 to i Next x
You touched on a lot of subjects in 45 minutes only which is absolutely great
Thank you for your effort in explaining the lessons .... Please I want to make a macro using loop to make specific values in cells based on a specific number in a specific cell
This is really awesome! i am clear on all the loops now, great learning, thank you for making such a good video.
Very good tutorial. Thank you.
Great Video! Very well explained.
Very helpful, thank you.
Great tutorial. Always nice to learn VBA
Great teaching skills sir :) !!!
Thank ya man
Hello, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 8" or for x = 1 to whatever . What if I wanted to be able to change the " 8 " element (end point) from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. Any suggestions? Thank you
You can declare upper range as inputbox and every time macro is run, user have to enter that value.
Dim i as variant
i = inputbox("Please input value")
x = 1 to i
Next x
@@ca_saurabhgoyal Thank you. Perfect. I will research syntax for inputbox.
2 questions how to start for loop in a cell other than A1, How to increment numbers by .50, I getting 6, 6.5, 7.5 ??? Thanks, Ed
If you want to run macro from cell B2, then add below code before macro
Range("B2").select
To increment by 0.5, need to declare variable like i = i +0.5