Excel Macro Class 5 - Get User Input - Message Box

Great video... question: how do you copy the data over as values with the same formats? I just need values and formats and not cell drop down lists and formulas.

Thank you, this was very informative, but how do i capture the value entered in the inputBox then take that value and enter it in a formula in macro?

Hey,

is there anyway to set the Criteria1 to be an user input?
please see the below:

Dim inputvalue As String
inputvalue = InputBox("enter partial name")


ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=8, Criteria1:="*inputvalue*", Operator:= _
xlFilterValues

Thanks

Great tutorials, really helpful ! All useful details included but nicely placed and explained, without getting boring. Can't wait to watch the rest of the material.

Perhaps it's sinking in faster, but that was the easiest tutorial up to now.

Sir, your tutorials are more informative, and able to understand each and every VBA line. Your explanation is very useful for us to understand the core. We expect a lot more videos about VBA from your channel. I noticed this channel was started long ago, more than 11 years back, but limited videos. We as subscribers and being VBA learners will not go through many channels, we prefer few channels covering almost major of the contents. We expect a lot of videos from you Sir. Thanks for your time and explanation!!

EXCELLENT TEACHER

Thank you!

Excellent tutorial thanks

Great Videos. Do you have other examples for each tutorials that we can practice on our own? Would be nice to have assigned exercises to do that will be reviewed shortly in the next video. I know we can make up our own exercises but I'm speaking on behalf of the lazy students.

Do you have about qrcode scanner for student attendance?

I had to define returnValue (Dim returnValue as Integer) to get this to work.

Great video.  Can you also create a video that generates a report by "start date" and "end date" using the "Data" sheet?

Yet again, an excellently delivered and very informative tutorial - from an oldie trying to learn VBA. Keep up the very good work!!

Great intro!