I dont know how this doesnt have more views. This one video solved 4 issues I had with my userform. THANK YOU SO MUCH!!! I dont know how I would have completed my project without this.
Thanks Nick! Not everybody wants to be an excel ninja like you and I and most people don't know it's possible or how simple it is or they'd watch it. Thanks bro! Dan
Thank you! i love your channel so much, i'm new to excel ms and this helped me create a database for my favorite books / phrases which i can also apply to contacts, addresses and record keeping :3
I love this user form. I have a use to do one like it, however, say instead of color you want a date field. When the data transfers back into the spreadsheet it appears to be coming over as text and not as a number format. The end result I am looking for is that the user enters the data using the user form, however, on the spreadsheet they could apply filters to the date column and filter by year, month, or date
Sir is there a way to put row nuber in text box and thats show data of row ? Or we search something in colam A and thats show serch data with row number in label or text box?
Dan, This video helped make life incredibly easier for administrative personnel needing to look-up daily activity reports at my workplace (THANK YOU!) We are having trouble with the multiple areas that the user enters time; when recalling the userform after entry has been submitted, the time is in Excel format. Is there a way to have it read in a preferred military time style? Secondly, would it be possible to add a button to an existing dashboard that would recall this code based on a search by user name and date of entry instead of having to go to the actual worksheet? Thanks! R
Nice work done, I want one more thing, I want to be able to call the form for edit with a User form button not a click on the excel sheet how do i do that, i have tried several ways but could not.
Does this workbook function mean that if you copy to a different workbook that it will then reference that workbook? and Is there a thissheet function that will do the same thing?
Awesome! Now how do I make another userform that will search the worksheet for data and pull up the userform you just made as the search result? Is that possible?
I have a ListBox in which multiple items can be selected. How do I get the selected items (which are stored in a single cell, separated by a comma) to populate the listbox in the userform? I have followed your example and am able to get all other fields to populate the userform for editing except for this field.
Hi, Thank you for your excellent tutorial. I have followed your instructions step by step but it keeps giving me a compile error saying method or data not found. I think it may be because of definiting x = me.lblrow. Is there another method of definiting x as the current row? Thanks in advance
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?
VLOOKUP on steriods or should I say HLOOKUP? Wonderful VBA tip can't wait to try it on my existing application. Thanks for offering the chance to learn.
sir i want help from you i want little change if you can for me 1-another in the same user form textbox for putting only row number and chek the data and change it and save back please it will give me allot help
269/5000 good afternoon. I do not speak English, but I'm studying. As much as I do not understand exactly what you're talking about, some things I understand because I like VBA, your videos are fine. Congratulations on your work, and thank you for sharing your knowledge. Hug.
Please could you please help me here. I have a table and I just want to dislplay everything inside this table in the VBA form. Could you please explain how to. I have been strugling with this for days
Hi Dan! Thank you very much for your help! You are awesome! I do have one more question about the same topic. Is there a way to highlight the next row as well on the sheet? So when I click the next/previous buttons, the macro at the same time highlights/activates the row that has been populated on the user form and deselects the previously populated row .
Thanks for explaining the reason for the property use as you code. Makes it much easier to understand, rather than just copying.. Thank you so much.
So Glad it was helpful! Thanks for the kind words!! 😁
I dont know how this doesnt have more views. This one video solved 4 issues I had with my userform. THANK YOU SO MUCH!!! I dont know how I would have completed my project without this.
Thanks Nick! Not everybody wants to be an excel ninja like you and I and most people don't know it's possible or how simple it is or they'd watch it. Thanks bro!
Dan
Thank you! i love your channel so much, i'm new to excel ms and this helped me create a database for my favorite books / phrases which i can also apply to contacts, addresses and record keeping :3
So glad it helps! Thanks for the sweet words!! 🥰🥰
The more I even watch you write code, the more I understand how to do it. Thanks for the example!
Warren,
That's fantastic! So glad this helps you!
Dan
Very awesome tutorials. I really appreciate your effort making all these videos.
Thanks Dan. Great tips. You could hide all columns except for the name. This would be useful in many applications.
krn14242 Cool idea krn14242! thanks!!!!
Dan
I love this user form. I have a use to do one like it, however, say instead of color you want a date field. When the data transfers back into the spreadsheet it appears to be coming over as text and not as a number format. The end result I am looking for is that the user enters the data using the user form, however, on the spreadsheet they could apply filters to the date column and filter by year, month, or date
Thanks you Dan, this is very helpful.
Great thanks bro
Welcome! Thank you
is it possible to use that for different sheets? I mean,load the userform from one sheet and make it to work to add the date to diferent sheets?
How would i add a next and previous button to this?
Sir is there a way to put row nuber in text box and thats show data of row ? Or we search something in colam A and thats show serch data with row number in label or text box?
Dan,
This video helped make life incredibly easier for administrative personnel needing to look-up daily activity reports at my workplace (THANK YOU!)
We are having trouble with the multiple areas that the user enters time; when recalling the userform after entry has been submitted, the time is in Excel format. Is there a way to have it read in a preferred military time style?
Secondly, would it be possible to add a button to an existing dashboard that would recall this code based on a search by user name and date of entry instead of having to go to the actual worksheet?
Thanks!
R
Nice work done,
I want one more thing, I want to be able to call the form for edit with a User form button not a click on the excel sheet how do i do that, i have tried several ways but could not.
is there a thissheet function that will still select this sheet even if the name changes and maybe change name references?
Thanks~it's really helpful!!
issac lin Very welcome!
Does this workbook function mean that if you copy to a different workbook that it will then reference that workbook? and Is there a thissheet function that will do the same thing?
Awesome! Now how do I make another userform that will search the worksheet for data and pull up the userform you just made as the search result? Is that possible?
Thank you dude.
You are so welcome, James! Glad it helps.
How can I use the form created above as both a way to input new records and modify existing records?
I have a ListBox in which multiple items can be selected. How do I get the selected items (which are stored in a single cell, separated by a comma) to populate the listbox in the userform? I have followed your example and am able to get all other fields to populate the userform for editing except for this field.
Hi, Thank you for your excellent tutorial. I have followed your instructions step by step but it keeps giving me a compile error saying method or data not found. I think it may be because of definiting x = me.lblrow. Is there another method of definiting x as the current row?
Thanks in advance
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?
VLOOKUP on steriods or should I say HLOOKUP? Wonderful VBA tip can't wait to try it on my existing application.
Thanks for offering the chance to learn.
You're so welcome! Dan
sir i want help from you
i want little change if you can for me
1-another in the same user form textbox for putting only row number and chek the data and change it and save back
please it will give me allot help
269/5000
good afternoon.
I do not speak English, but I'm studying.
As much as I do not understand exactly what you're talking about, some things I understand because I like VBA, your videos are fine.
Congratulations on your work, and thank you for sharing your knowledge.
Hug.
Thanks for the kind words and the hug. Right back at you!! :)
Please could you please help me here. I have a table and I just want to dislplay everything inside this table in the VBA form. Could you please explain how to. I have been strugling with this for days
I got the following error (x = Me.LblRow) it won't compile nor update the record: I really need this last component to work Help :(
Hi Steven,
Can you show us the code you used so we can better assist?
Thanks
Dan
@Chad H I can help you with it, if you're still struggling.
How to go down or up to the next selected row by clicking the NEXT BUTTON in the user form?
Hi Elza,
I made a video to help you: ruclips.net/video/ZWQzGXhQLDg/видео.html
Thanks
Dan
Hi Dan! Thank you very much for your help! You are awesome! I do have one more question about the same topic. Is there a way to highlight the next row as well on the sheet? So when I click the next/previous buttons, the macro at the same time highlights/activates the row that has been populated on the user form and deselects the previously populated row .
Elza Sayfullina um yep. Lemme see, try something like
Rows(x & ":" & x).entirerow.select
@Melchor Figueroa I can help you my friend, let me know if you need my help.
if not intersect() is nothing then DOES NOTHING FOR THIS CODE!!!
It's useless, only sets the working range to be in a2 to z10000, which is meaningless
@A King of you're still struggling, I can help...
why you take me too long for watching just tell me how to save