VBA for Beginners - VBA Input Box

[@ronnie2440]

You are the best and lovely person I've ever see online with great love to help others to success. You are too much that I have no words to describe what I think about you. I'm starting my excel learning trip and I know you will always be with me on the road. Thanks. Ronnie

[@youssefelbourakkadi7246]

It is possible to run inputbox and keeping control on excel ?

[@mcgyvernatividad5036]

Hi, how about 2 textbox that will be stored in one excel cell... For example name... Textbox first name, textbox middle name, textbox last name... The it will be saved in one cell like A2 cell in excel database... Thank you

[@josebetancourt5890]

love your videos! very educational focus and Interesting approach!

[@OnLinePCLearning]

Appreciated Trev

[@ritafeiring]

Thanks a lot useful for me as a beginnner. Well explained :-)

[@OnLinePCLearning]

Thanks Rita Trev

[@anorenbergs]

Very nice videos! Good job, Trevor!

[@OnLinePCLearning]

Hi Aivars, Thank for the feedback. Much appreciated. Trev

[@fabriciocarranza7044]

Very helpful, thank you for sharing your knowledge

[@ibtisamabdo3559]

Excellent tutorial , thank you very much.

[@lars6220]

I do not really much because I do not know whether you need to create a new macro or not and if so how?

[@MahendraTita]

Good Explained Video, Thank you for sharing....

[@saeedalikhan7128]

10000000000000 likes for your videos Sir Trevor thanks to U

[@OlegBedriy]

I hope he's doing fine - It was some time since he stopped uploading.

[@keithrocknrolls]

Hi Trevor I am trying to create this code, but I am getting no further than Set AddData as I get Run-time error '1004' Application-defined or object-defined error. Code is listed as below: Thanks for any help Sub Login() Dim AddData As Range Dim AddName As String Set AddData = Cells(Rows.Count, 1).End(x1Up).Offset(1, 0) AddName = InputBox("Type Your First Name", "Add Name") If AddName = Empty Then Exit Sub AddData.Value = AddName AddData.Offset(0, 1).Value = Now End Sub

[@OnLinePCLearning]

Hi Michael, Here is a link to the web article for this video. www.onlinepclearning.com/vba-beginners-vba-input-box-examples/ Trev

[@LPadillaCR]

SUPERB!!! I remove my hat before you Mr. Easton.

[@mukeshiit-kgp8954]

Can u please upload video on Kruskal algorithm in vba

[@theblackstallian5976]

how can I do this for data forms??

[@mohamadsiddeek7912]

Hi, indeed!I have learned much cording system in Excel VBA by your support.please help me to get calculate from top to bottom mostly I found left to right, this is like a day book in a day book if we enter few journal it should give total in a below row again enter that total has to go below row and should give total and this total only has to next sheet how can solve this matter by excel VBA. please don't ignore this question. God bless you and thanks in advance,

[@saeedalikhan7128]

lovely and very nice video thanks sir Trevor Easton

[@niphaphatr1]

Thank you verymuch.

[@razoolmohideen8365]

How to use password character " * " when using the input boxes to enter password Thanks vba learner

[@hafizurrahman7334]

I

[@lars6220]

oh and this is the problem why its not working Set addData = Cells(Rows.Count, 1).End(x1Up).Offset(1, 0)

[@rajeshmajumdar4999]

Lovely!!!

[@mostafa88820]

thnx alot

[@michaelross3880]

Thank you for these videos, I am watching and going along with you. I am having a problem with the code. I followed exactly what you have and I get "Object variable or with block variable not set". I hit Debug and it highlights this "AddData.Value = Nme. I am very new to this but you're making it very easy to learn and this seems right. I am listing the entire code below. Please help. Sub Login3() Dim AddData As Range Dim Nme As String Set AddDatat = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) Nme = Application.InputBox("Add Name", Type:=2) Auth = 0 For Each cName In Range("D2:D14") If cName.Text = Nme Then AddData.Value = Nme AddData.Offset(0, 1).Value = Now MsgBox "Welcome:-" & Nme Auth = 1 Exit For End If Next cName If Auth = 0 Then MsgBox "You are not authorixed" End Sub

[@OnLinePCLearning]

Michael Ross Hi Michael, Set AddDatat should be AddData best wishes Trev

[@michaelross3880]

Trevor Easton Thank you

[@tasoskatsikoagiannis3564]

Dislike as you ignore left and top.