I guess Im asking the wrong place but does anyone know a tool to log back into an instagram account?? I stupidly lost the account password. I appreciate any help you can give me!
@Blake Matthew thanks so much for your reply. I found the site on google and Im in the hacking process now. Takes quite some time so I will reply here later with my results.
Thank you so much Dr. Your explanation is so short,precise and simple to understand. I wish I would spend my money to such professors in school to learn coding and developing applications of different types.
This is the best VBA tutorial! TBH, i've been trying to learn this VBA for over a week now and some tutorials are just full of nonsense talking which makes it more difficult. But i have a concern though, hopefully someone can resolve this. I followed everything exactly on the video, but i want my textbox1,2,and 3 to enter data on the columns i need them to be on, not following the Active Cell like used in the video. Any suggestions?
Hi Doc, I am working on this data entry worksheet and this video definitely helped me. However, I want to know how to assign the data to a specific cell in the excel worksheet instead of having it pop out to an active cell. This eases the user from having to point to a specific cell before they start loading the data. Thank you
Use VBA code to navigate to the correct active cell. I usually name the upper left cell in the data table. I select that cell first with code. (cell name.select). From there, using VBA, I do an “end down” move to get to the bottom row in the table and make that the active cell. From there you do the offsets.
Man this helped tremendously and did exactly what I wanted and nothing more, fantastic job on the explanations of what is happening with each line of code. I do have one question though, is there a way to have it select the next empty cell/row when the UserForm intializes? This is in case you had click somewhere else in the sheet before starting your userform, because as is, it just enters the info wherever the cursor was placed before initialization.
thank you for these lessons. it's so interesting, but I have a question. I want to know how did you manage to always have the cell (1,1) active at the start.
Thanks you for the work you have done here. After entering your prescribed code the UserFprm is great, however it dors not transfer to the spreadsheet. I get an error code "Run-Time error '424':. I do not see how the code knows where the first cell on the spreadsheet. I am sure I have missed something but not sure what it is. Thanks for Your help. Kevin
Thank you very much sir. Could you please help me out in writing code if the destination is an excel table which can expand as the new data entered. Thank you once again.
Thanks for this video... with the help of this video i am able to create userform and also able to add data to my sheet.. But in the last when i am closing my file.. not able to open it again, will you plz help me to save that file where i can work again on the same sheet for updating my sheet
dear Todd grand that was very helpful and thanks a lot for your great effort but i faced an issue using the UserForm when it add data from the user form to a sheets (numbers) it appears as texts and i manually change them to numbers so if there an equation it doesn't reflect automatically so do you have a solution for that
Is there a way to create a userform with questions and info for/from clients that can somehow be filled into their specific spots on a worksheet that is set up like a printable document and not just data lined up in columns and rows?
want to build an online form but the online form builders doesn't achieve my needs so made my own from VBA userform. is it possible to publish the VBA userform into website without losing functionality?
Hello ! I have an Excel form with two text boxes. I would like to display the result in figures in the first text area of the userform and the same result but in letters in the second text area of the userform. I have the Excel function of translating numbers into letters. But I do not know how to take me so that a click of a command button can simultaneously display this result in the text areas of the userform. Thank you for helping me !
Hello ! I have an Excel form with two text boxes. The first must display the result in figures of an operation; The second must display this same but in letters. I have the function of translating numbers into letters. But I do not know how to take me so that a click of a control button can simultaneously operate the operations. Thank you for helping me!
I have a quick queation: let's say the user after entering the date he clicked on a cell outside this range, and saved the sheet. The next time the user inputs more data it will be saved outside this range. What I am trying to say is: how to automatically keep the focus on the range of those 3 columns even if the user mistakingly click on a cell in row E and saves? Thanks
Hi. I have a question. Let's say if we have 80 data in the ID column. And we want to stop the form at the 80th record and it must also display a message box saying something like "You have reached the maximum limit or the last row" and the user must not be able to add any other record to it. So, what is going to the code for that? Thanks a lot. =)
How would you add additional data to the same name ? Example List of golfers have new scores each week , you want to add John's new score while keeping his previous scores in tact .
Hi Todd, can you help me with one thing I am stuck with, tried many ways but not working. I am writing a userform with a submit button to load data on userform to a spreedsheet. problem is i want excel to choose the next available record number( or row) from the spreedsheet. I tried vlookup, rowX, . please help me out?
The ActiveCell code is unstable, if the cell highlighted (ActiveCell) before opening the form is cell A2, the data will be entered int the right column, else say the highlighted cell (Active Sheet) before opening the form is D7, the data will paste in D7, D8, D9... I would love a fix to this... If it means defining a range or setting an absolute string... Thanks in advance.
I have everything working like you showed me to do, But It will not start at the next available row when I enter Data in the form, I have to manually click on the empty row and start my data entry and then it will line up correctly, What di I do wrong?
Hello Sir, Its Amazing and very useful. I tried and its working perfectly. but when i using this method for number, my cell storing , showing number but cell is text formatted. so that cell number not identifying vlookup. please advise how it save as number
Hi, I would like to thank you for making this tutorial it helps me build my encoding worksheet more convenient. I would like to ask you on something maybe I missed. I have done everything what you have instructed and the program works but its showing the data in different cell on my worksheet. Can you get back on me and help me with this issue. Thank you.
I used this code to create a userform and it worked perfect. I tried to modify it by changing the last activecell.offset command to use a combo box instead of a text box. I am getting a Run-time error '424' Object required. What am I doing wrong?
Hi, lets say I have a database filled with data. When I click the button, is there a way for it to create the data automatically on an available cell (not filled with data)? As now I have to move my mouse cursor over an available cell for the button to enter the data correctly.
CODE FOR THE USERFROM: --------------------------------------------------------------------------------------------------------------------- Private Sub CommandButton1_Click() If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3.Value = "" Then If MsgBox("Form is not cople. Do you want to continue?", vbQuestion + vbYesNo) vbYes Then Exit Sub End If End If If ActiveCell.Offset(1, 0).Value "" Then ActiveCell.End(xlDown).Offset(1, 0).Activate End If ActiveCell = TextBox1.Value ActiveCell.Offset(0, 1) = TextBox2.Value ActiveCell.Offset(0, 2) = TextBox3.Value ActiveCell.Offset(1, 0).Select Call resetFrom End Sub Sub resetFrom() TextBox1.Value = "" TextBox2.Value = "" TextBox3.Value = "" UserForm1.TextBox1.SetFocus End Sub --------------------------------------------------------------------------------------- THIS CODE IN YOUR SHEET CODE: ---------------------------------------------------------------------------------------- Sub formulier() ActiveSheet.Range("B2").Activate UserForm1.Show UserForm1.TextBox1.SetFocus End Sub --------------------------------------------------------------------------------------------
I need little favor and help from you. how I will do it. Let say I have two column A and B. I want to use vba loop in excel, I want to add A1 and A2 and the result will display in B2 and also if I will add A3 and A2 the result will display in B3 and so on as long as column A is not empty and will go down continuously. Your help greatly appreciated. Thanks
I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a userform in the beginning or the end of the presentation that would allow users to fill and submit the feedback/registrations? Could an embedded Excel w/VBA help with this?
Hi, I have a piece of code9below) that finds the last row in a data sheet and then adds values from the controls on the user form ( all controls a named Reg 1-10 except for a combo box I have named cbo name. 'change the number for the number of controls on the userform cNum = 10 'add the data to the selected worksheet Set nextrow = Sheets(sht).Cells(Rows.Count, 3).End(xlUp).Offset(1, 0) For X = 1 To cNum nextrow = Me.Controls("Reg" & X).Value how can I concantanate on the data sheet two of the controls values (cbobox and reg)onto one line in the cell ie : MaterialType with Material Description ie :Fitting - Pipe elbow
Wow!!! I watch your channel for not excel things and it's fun to see you also created excel videos
I've viewed several tutorials on simple userform and I find yours as the one I feel most comfortable with! Thanks for this!
I guess Im asking the wrong place but does anyone know a tool to log back into an instagram account??
I stupidly lost the account password. I appreciate any help you can give me!
@Anderson Charles instablaster =)
@Blake Matthew thanks so much for your reply. I found the site on google and Im in the hacking process now.
Takes quite some time so I will reply here later with my results.
@Blake Matthew it worked and I actually got access to my account again. Im so happy!
Thank you so much, you saved my ass !
@Anderson Charles Glad I could help :)
Thank you so much Dr. Your explanation is so short,precise and simple to understand. I wish I would spend my money to such professors in school to learn coding and developing applications of different types.
You're welcome, thanks for watching -
Nicely presented and explained. It is clear
Excel has many features that seem complicated but once you input the configurations its very useful at the end.
Good job Dr.Todd. Thanks for sharing.
Short and simple. thanks!
!Wow! easy to follow, and at the same time VERY helpfull codes. Thanks for devoting your time to share with the world.
You're welcome -
Great video! Helped me out a lot with what I was trying to do with my UserForm.
very simple and usefull thanks a lot
super thanks for this video! helped me fix my problem in vba
Excellent!
Thank you and thanks for watching -
Can we create cash denomination control system by using Excel VBA for cash counter to record transactions in cash
Very helpful. Thank you.
This is the best VBA tutorial! TBH, i've been trying to learn this VBA for over a week now and some tutorials are just full of nonsense talking which makes it more difficult. But i have a concern though, hopefully someone can resolve this. I followed everything exactly on the video, but i want my textbox1,2,and 3 to enter data on the columns i need them to be on, not following the Active Cell like used in the video. Any suggestions?
Really you are always Brilliant and estimable good luck Dr. Todd. I feel lucky and pleased to watch your informative videos, great thanks
Thank you so much and thanks for watching -
thanks Mr.Todd and Mr Dinesh Kumar
Thankyou so much for taking the time to share this Information , it worked great for what I needed .
You're welcome!
Great video
Thank you very much, sir.
Thank you. how do I put the combo box value directly a specific cell directly? without no offset
Using Range("the number of the cell").value = textbox#.Value
Hi Doc, I am working on this data entry worksheet and this video definitely helped me. However, I want to know how to assign the data to a specific cell in the excel worksheet instead of having it pop out to an active cell. This eases the user from having to point to a specific cell before they start loading the data. Thank you
Use VBA code to navigate to the correct active cell. I usually name the upper left cell in the data table. I select that cell first with code.
(cell name.select). From there, using VBA, I do an “end down” move to get to the bottom row in the table and make that the active cell. From there you do the offsets.
Man this helped tremendously and did exactly what I wanted and nothing more, fantastic job on the explanations of what is happening with each line of code. I do have one question though, is there a way to have it select the next empty cell/row when the UserForm intializes? This is in case you had click somewhere else in the sheet before starting your userform, because as is, it just enters the info wherever the cursor was placed before initialization.
thank you for these lessons. it's so interesting, but I have a question. I want to know how did you manage to always have the cell (1,1) active at the start.
Realy Awsome Teaching
thank god for you. i already fixed my program
I'm glad you found the video useful - thanks for watching -
Very clear and instructive tutorial dr. thanks! It helps me a lot! Cheers! ;)
How to add a counter for each register? In other colum
Thanks you for the work you have done here. After entering your prescribed code the UserFprm is great, however it dors not transfer to the spreadsheet. I get an error code "Run-Time error '424':. I do not see how the code knows where the first cell on the spreadsheet. I am sure I have missed something but not sure what it is. Thanks for Your help. Kevin
Thank you very much sir.
Could you please help me out in writing code if the destination is an excel table which can expand as the new data entered.
Thank you once again.
Thanks for this video...
with the help of this video i am able to create userform and also able to add data to my sheet.. But in the last when i am closing my file.. not able to open it again, will you plz help me to save that file where i can work again on the same sheet for updating my sheet
dear Todd grand that was very helpful and thanks a lot for your great effort
but i faced an issue using the UserForm
when it add data from the user form to a sheets (numbers) it appears as texts and i manually change them to numbers so if there an equation it doesn't reflect automatically so do you have a solution for that
Thank you so much for the tutorial. excellent..!
You're welcome -
thank you
Thanks.
thanks lot, short and easy
You're welcome, thanks for watching -
This was very helpful! Thank you so much! :)
You're welcome!
very nice and use full to me
Thank you -
I have a caution when I click on my form: "Object Required" What does this mean?
after completing the formula, type in the active cell formula again and dont copy paste. that helped with mine. for some reason.
Is there a way to create a userform with questions and info for/from
clients that can somehow be filled into their specific spots on a
worksheet that is set up like a printable document and not just data
lined up in columns and rows?
want to build an online form but the online form builders doesn't achieve my needs so made my own from VBA userform.
is it possible to publish the VBA userform into website without losing functionality?
Hello ! I have an Excel form with two text boxes. I would like to display the result in figures in the first text area of the userform and the same result but in letters in the second text area of the userform. I have the Excel function of translating numbers into letters. But I do not know how to take me so that a click of a command button can simultaneously display this result in the text areas of the userform. Thank you for helping me !
traightforward, thank you Todd
You're welcome -
Hello ! I have an Excel form with two text boxes. The first must display the result in figures of an operation; The second must display this same but in letters. I have the function of translating numbers into letters. But I do not know how to take me so that a click of a control button can simultaneously operate the operations. Thank you for helping me!
I have a quick queation: let's say the user after entering the date he clicked on a cell outside this range, and saved the sheet. The next time the user inputs more data it will be saved outside this range. What I am trying to say is: how to automatically keep the focus on the range of those 3 columns even if the user mistakingly click on a cell in row E and saves?
Thanks
Could you please explain why setting the default value = true enables the user to click the enter button instead of clicking " enter " ?
Hi Dr. Todd, my second input does not go to the next row. It overwrites the first row. Any suggestions?
Hi. I have a question. Let's say if we have 80 data in the ID column. And we want to stop the form at the 80th record and it must also display a message box saying something like "You have reached the maximum limit or the last row" and the user must not be able to add any other record to it. So, what is going to the code for that? Thanks a lot. =)
How would you add additional data to the same name ? Example List of golfers have new scores each week , you want to add John's new score while keeping his previous scores in tact .
Using this user form and starting in the first cell. How do I stop it from going to that cell every time I use the User Form.
Hi Todd, can you help me with one thing I am stuck with, tried many ways but not working. I am writing a userform with a submit button to load data on userform to a spreedsheet. problem is i want excel to choose the next available record number( or row) from the spreedsheet. I tried vlookup, rowX, . please help me out?
How the executable file created of vba user form and excel sheet ?
The ActiveCell code is unstable, if the cell highlighted (ActiveCell) before opening the form is cell A2, the data will be entered int the right column, else say the highlighted cell (Active Sheet) before opening the form is D7, the data will paste in D7, D8, D9...
I would love a fix to this... If it means defining a range or setting an absolute string...
Thanks in advance.
I have everything working like you showed me to do, But It will not start at the next available row when I enter Data in the form, I have to manually click on the empty row and start my data entry and then it will line up correctly, What di I do wrong?
How does that form become a macro? I do all the steps but it isn't on the macro list
How did you get the inputted data to go in the correct cells? Say for example, I want the first first name to go in cell H5.
Tony Worrell you have to select cell H5, it will be assigned as (0,0) from there the formula makes sure the values are entered in sequence.
Hello Sir, Its Amazing and very useful. I tried and its working perfectly. but when i using this method for number, my cell storing , showing number but cell is text formatted. so that cell number not identifying vlookup. please advise how it save as number
Hi, I would like to thank you for making this tutorial it helps me build my encoding worksheet more convenient. I would like to ask you on something maybe I missed. I have done everything what you have instructed and the program works but its showing the data in different cell on my worksheet. Can you get back on me and help me with this issue. Thank you.
Wonderful!!
Thank you and thanks for watching -
I used this code to create a userform and it worked perfect. I tried to modify it by changing the last activecell.offset command to use a combo box instead of a text box. I am getting a Run-time error '424' Object required. What am I doing wrong?
What if I want the database to be on another sheet?
Next entry or Provious entry ???
Hi, lets say I have a database filled with data. When I click the button, is there a way for it to create the data automatically on an available cell (not filled with data)? As now I have to move my mouse cursor over an available cell for the button to enter the data correctly.
Did you found out how to set it below previous cells?
CODE FOR THE USERFROM:
---------------------------------------------------------------------------------------------------------------------
Private Sub CommandButton1_Click()
If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3.Value = "" Then
If MsgBox("Form is not cople. Do you want to continue?", vbQuestion + vbYesNo) vbYes Then
Exit Sub
End If
End If
If ActiveCell.Offset(1, 0).Value "" Then
ActiveCell.End(xlDown).Offset(1, 0).Activate
End If
ActiveCell = TextBox1.Value
ActiveCell.Offset(0, 1) = TextBox2.Value
ActiveCell.Offset(0, 2) = TextBox3.Value
ActiveCell.Offset(1, 0).Select
Call resetFrom
End Sub
Sub resetFrom()
TextBox1.Value = ""
TextBox2.Value = ""
TextBox3.Value = ""
UserForm1.TextBox1.SetFocus
End Sub
---------------------------------------------------------------------------------------
THIS CODE IN YOUR SHEET CODE:
----------------------------------------------------------------------------------------
Sub formulier()
ActiveSheet.Range("B2").Activate
UserForm1.Show
UserForm1.TextBox1.SetFocus
End Sub
--------------------------------------------------------------------------------------------
what if have multiple textbox?
how can i if/or code?
you are great
how about deleting data on data grid?
How to center the address of the user form. When creating a username and password form
How to protect the sheet? while the entry form is working.
How do I move to the next cell down each time I click enter button
I need little favor and help from you. how I will do it. Let say I have two column A and B. I want to use vba loop in excel, I want to add A1 and A2 and the result will display in B2 and also if I will add A3 and A2 the result will display in B3 and so on as long as column A is not empty and will go down continuously. Your help greatly appreciated. Thanks
I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a userform in the beginning or the end of the presentation that would allow users to fill and submit the feedback/registrations? Could an embedded Excel w/VBA help with this?
But I need help, My Form is not opening when i assign a macro
Hi how to do the same in c#
nice. thx
Thank you very much sir, kindly share the code bcz the video is not clear. Hope u will respond it.
Hi,
I have a piece of code9below) that finds the last row in a data sheet and then adds values from the controls on the user form ( all controls a named Reg 1-10 except for a combo box I have named cbo name.
'change the number for the number of controls on the userform
cNum = 10
'add the data to the selected worksheet
Set nextrow = Sheets(sht).Cells(Rows.Count, 3).End(xlUp).Offset(1, 0)
For X = 1 To cNum
nextrow = Me.Controls("Reg" & X).Value
how can I concantanate on the data sheet two of the controls values (cbobox and reg)onto one line in the cell ie : MaterialType with Material Description ie :Fitting - Pipe elbow
we can we get all the codes
I need help
Calculate range of days using DTPicker in excel vba.
Does this video help? th-cam.com/video/9QVUfoelFP0/w-d-xo.html
Thank you very much.
how could be with c#
Thanks!
You're welcome!
New member
awesome can i have a copy of the code please TY
This training is good, but "fonts" too small. How possible if you enlarge percentage. Anyway, thank you for good tutorial.
That's really good one....can u plss give this format I need this for my work
Dear Would you write us the codes pls
I want your help very badly please response
Can’t see your code. It’s blurry.
Great tutorial its very simple. I did not see any dim's still manage to get what im looking for :) add me up to your subscribers
WHAT IS THIS
छी
hfv