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
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
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
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,
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
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
It is possible to run inputbox and keeping control on excel ?
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
Can u please upload video on Kruskal algorithm in vba
how can I do this for data forms??
I do not really much because I do not know whether you need to create a new macro or not and if so how?
love your videos! very educational focus and Interesting approach!
Appreciated
Trev
Very nice videos! Good job, Trevor!
Hi Aivars,
Thank for the feedback. Much appreciated.
Trev
Thanks a lot useful for me as a beginnner. Well explained :-)
Thanks Rita
Trev
Very helpful, thank you for sharing your knowledge
Good Explained Video, Thank you for sharing....
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
Hi Michael,
Here is a link to the web article for this video.
www.onlinepclearning.com/vba-beginners-vba-input-box-examples/
Trev
I hope he's doing fine - It was some time since he stopped uploading.
Excellent tutorial , thank you very much.
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,
10000000000000 likes for your videos Sir Trevor thanks to U
lovely and very nice video thanks sir Trevor Easton
SUPERB!!! I remove my hat before you Mr. Easton.
How to use password character " * " when using the input boxes to enter password
Thanks
vba learner
I
Thank you verymuch.
oh and this is the problem why its not working Set addData = Cells(Rows.Count, 1).End(x1Up).Offset(1, 0)
thnx alot
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
Michael Ross
Hi Michael,
Set AddDatat should be AddData
best wishes
Trev
Trevor Easton Thank you
Lovely!!!
Dislike as you ignore left and top.