Thank you for your excellent tutorial. Is it possible to print just based on “the search result list” instead of printing all the data from the sheets? Thank you.
Hello Sir, I am one of your subscribers and I must say your videos are really outstanding. Can application of this such be integrated into google appsheet for sharing on phones?
Great video, thank you very much. Please, Suppose I am working with 4 different worksheets in my excel file and I have created a userform having a combo-box (with the worksheets as its content) and a list-box, how can I make the list-box display the data for a given selection from the combo-box?
Watch the video below, it may answer your question How to Create Data Entry Form with Multiple Search function and Protection in Excel : ruclips.net/video/wMmsmolIX_k/видео.html
greetings sir, your videos have been very helpful. i encounter a problem which is the delete function doesn't work when i want to delete data from another sheet is not the current sheet
Great video DJ Oamen, thank you for taking the time to do this. Am i missing something on the Update button... i cannot see where you have defined the 'updaterow' variable? Code I have used is as follows which I am pretty sure is exactly as you show in the video: Private Sub UpdateButton_Click() Dim answer Dim updaterow answer = MsgBox("Confirm if you want to update the record?", vbYesNo + vbQuestion, "Update Record") If answer = vbYes Then Cells(updaterow, 1) = DateInput.Text Cells(updaterow, 2) = PrevDayInput.Text Cells(updaterow, 3) = GPTodayInput.Text Cells(updaterow, 4) = EDStreamInput.Text Cells(updaterow, 5) = EDNewPushInput.Text Cells(updaterow, 6) = EDNewPullInput.Text Cells(updaterow, 7) = NewOtherInput.Text Cells(updaterow, 8) = FollowUpInput.Text Cells(updaterow, 9) = DTAInput.Text Cells(updaterow, 10) = SentToEDInput.Text End If End Sub Thanks, Doug
Many thanks for fir you video I followed from scratch. I do however have one problem with the reset code. When I run it it this line For I=0 To Me. lstDisplay.ListCount -1. The Me.lstDisplay is highlighted Any reason why this is happening
Always check your code and watch the video tutorial carefully . See solution below Dim i For i = 0 To Me.lstDisplay.ListCount - 1 If Me.lstDisplay.Selected(i) Then Me.lstDisplay.Selected(i) = False Next i
Update button do not work. Error 1004 Application or object defined error pops out. I tried debugging and it points to this code. Cells(updateRow, 1) = txtItemNumber.Text ItemNumber is my textbox Name. I hope you can help with this problem. Thanks!
Thank you for your code. I resolved a few errors, but I'm still having a problem with the spin button stopping at the record at A100 in my spreadsheet. I modified your Excel spreadsheet to include 150 entries. I have the same problem in your UserForm with the spin button stopping at record at A100. Thanks in advance for your help.
@@DJOamen Do you know why the spin button doesn't progress through all the records but instead stops at the 99th record (A100). I have a total of 171 records and would like the spin button to progress through all the records. Thanks in advance for your assistance.
In cell A1 I typed Reference No. However my lstDisplay shows the header name as Column A. How do I make Reference No the Column name? Did I miss a step?
Hi, great video and I’m nearly there but search function isn’t working. My code is not throwing any errors but when I search it just says invalid search even though I can see what I’m searching in the list
@@DJOamen ok so I have checked and I think it is the range section. It will only return search results on the first column. However the first column in my spreadsheet is title ( mr, mrs etc). What do I change the range to so I can search using all details? (Surname, Postcode, etc)
Watch this video tutorial How to Create Data Entry Form with Multiple Search function and Protection in Excel: ruclips.net/video/wMmsmolIX_k/видео.html
wow very nice video , i wish more succes for you mr oamen , is there a way to add a copy button that it can copy selected row into an other sheet ? i tried to add codes but it seems to not work for me , any help ?
Sorry my error, see the correct link below. How to Transfer Data from a UserForm into Multiple Worksheet in Excel VBA ruclips.net/video/SZG3sZNYyHc/видео.html
Channel Members can Download the Excel VBA Data Entry Form with Update, Search Function and modify it for their own personal use: drive.google.com/file/d/1NsW4aZf8cAXaaUJLLpZB_2re4ijarx2H/view?usp=sharing
![YoungBoy Never Broke Again - Sneaking [Official Video]](http://i.ytimg.com/vi/1ILUps2zDFU/mqdefault.jpg)
Thank you so much for your tutorial! I learned a bunch!
You are so welcome!
Well done on the tutorial!
Glad you liked it!
Thank you so much for the tutorial!!
Any time!
Thank you for your excellent tutorial. Is it possible to print just based on “the search result list” instead of printing all the data from the sheets? Thank you.
Yes is possible, but is not covered in this tutorial
Great Work Sir, One more important field is Picture.Then this was awsome.
Thanks K👌
Cool, thanks
No problem!
Hello Sir, I am one of your subscribers and I must say your videos are really outstanding. Can application of this such be integrated into google appsheet for sharing on phones?
Yes, you can
Great video, thank you very much.
Please,
Suppose I am working with 4 different worksheets in my excel file and I have created a userform having a combo-box (with the worksheets as its content) and a list-box, how can I make the list-box display the data for a given selection from the combo-box?
Watch the video below, it may answer your question
How to Create Data Entry Form with Multiple Search function and Protection in Excel :
ruclips.net/video/wMmsmolIX_k/видео.html
greetings sir, your videos have been very helpful. i encounter a problem which is the delete function doesn't work when i want to delete data from another sheet is not the current sheet
See the description area of the video for a solution
Very good for working
Thanks
Great video DJ Oamen, thank you for taking the time to do this. Am i missing something on the Update button... i cannot see where you have defined the 'updaterow' variable?
Code I have used is as follows which I am pretty sure is exactly as you show in the video:
Private Sub UpdateButton_Click()
Dim answer
Dim updaterow
answer = MsgBox("Confirm if you want to update the record?", vbYesNo + vbQuestion, "Update Record")
If answer = vbYes Then
Cells(updaterow, 1) = DateInput.Text
Cells(updaterow, 2) = PrevDayInput.Text
Cells(updaterow, 3) = GPTodayInput.Text
Cells(updaterow, 4) = EDStreamInput.Text
Cells(updaterow, 5) = EDNewPushInput.Text
Cells(updaterow, 6) = EDNewPullInput.Text
Cells(updaterow, 7) = NewOtherInput.Text
Cells(updaterow, 8) = FollowUpInput.Text
Cells(updaterow, 9) = DTAInput.Text
Cells(updaterow, 10) = SentToEDInput.Text
End If
End Sub
Thanks,
Doug
24 minutes into the video tutorial you will see the variable declared.
Dim updaterow as Integer
@@DJOamen thank you, i will go through it again.
Can i buy the billing invoice that can search name, save, and add new bill amount but same customer name?
I don't have what you want, software development firm can sell that to you
Many thanks for fir you video I followed from scratch. I do however have one problem with the reset code. When I run it it this line For I=0 To Me. lstDisplay.ListCount -1. The Me.lstDisplay is highlighted
Any reason why this is happening
Always check your code and watch the video tutorial carefully . See solution below
Dim i
For i = 0 To Me.lstDisplay.ListCount - 1
If Me.lstDisplay.Selected(i) Then Me.lstDisplay.Selected(i) = False
Next i
@@DJOamen thank you but I do have the same code as in your response and it just showing Method or Data member not found
im stuck at (addnew.Offset(0, 0).Value = txtref.Text) telling me variable not defined. when i press F5 please help
Watch the tutorial carefully
Update button do not work. Error 1004 Application or object defined error pops out. I tried debugging and it points to this code.
Cells(updateRow, 1) = txtItemNumber.Text
ItemNumber is my textbox Name. I hope you can help with this problem. Thanks!
Watch the tutorial carefully and check your code
Thank you for your code. I resolved a few errors, but I'm still having a problem with the spin button stopping at the record at A100 in my spreadsheet. I modified your Excel spreadsheet to include 150 entries. I have the same problem in your UserForm with the spin button stopping at record at A100. Thanks in advance for your help.
I have never tried A100, well that's good to know. Have a nice one
@@DJOamen Do you know why the spin button doesn't progress through all the records but instead stops at the 99th record (A100). I have a total of 171 records and would like the spin button to progress through all the records. Thanks in advance for your assistance.
Select the SpinButton, and then go to the Properties,
On the Properties, change the Max from 100 to 200
For example
Max = 200
Now Test your project
Check your mail solution sent to your email.
@@DJOamen, Great! Thanks for your help!
Can I hire you for a project lbvs
Project Ligand-Based Virtual Screening - No because of the cost it requires for development. Good luck
In cell A1 I typed Reference No. However my lstDisplay shows the header name as Column A. How do I make Reference No the Column name? Did I miss a step?
Check your codes
@@DJOamen Thank you. I am VERY grateful for this video.
Hi, great video and I’m nearly there but search function isn’t working. My code is not throwing any errors but when I search it just says invalid search even though I can see what I’m searching in the list
Check your code and try again
@@DJOamen ok so I have checked and I think it is the range section. It will only return search results on the first column. However the first column in my spreadsheet is title ( mr, mrs etc). What do I change the range to so I can search using all details? (Surname, Postcode, etc)
Watch this video tutorial
How to Create Data Entry Form with Multiple Search function and Protection in Excel: ruclips.net/video/wMmsmolIX_k/видео.html
@@DJOamen ah mate fantastic! Will try this out in the morning. I’m sure I’ll have some more questions 😂
@@DJOamen thank you 🙏
Hi, Captain! This string is highlighted in yellow "iSearch = Worksheets("Sheet14").Range("A1").CurrentRegion.Rows.Count." Any solution for this issue?
In my tutorial is not Sheet14, check your code
@@DJOamen please check my message you assistance is required
Sir, I can't figure out why the "lblDate.Caption = Format (Date, "ddd d mmm yyyyy")" returns a compile error message: variable not found? Any help?
lblDate.Caption = Format (Date, "dddd mmm yyyyy")
@@DJOamen The same error message still exists? What could be wrong?
@@DJOamen I copied your text string above but to no avail.
Private Sub UserForm_Initialize()
lblDate.Caption = Format(Date, "ddd d mmm yyyy")
End Sub
Very good sir, I love it. But can you please create one in Python using tkinter. Please Captain Paul
Will do
wow very nice video , i wish more succes for you mr oamen ,
is there a way to add a copy button that it can copy selected row into an other sheet ? i tried to add codes but it seems to not work for me , any help ?
Yes, you can do it. Watch this video it will show you how to transfer data onto multiple Worksheet: Link corrected:
ruclips.net/user/videoSZG3sZNYyHc
@@DJOamen somehow the link dosn't open , can you please write the title of it ? and thank you for the reply
Sorry my error, see the correct link below.
How to Transfer Data from a UserForm into Multiple Worksheet in Excel VBA
ruclips.net/video/SZG3sZNYyHc/видео.html
Delete Button is not working, Error Says: Variable is not defined- The variable is --- lst.Display. What should I do?
The listbox was changed to lstDisplay
not (lst.Displsy)
great video sir but i cant get the file. a little help please. Thanks
Channel Members can Download the Excel VBA Data Entry Form with Update, Search Function and modify it for their own personal use:
drive.google.com/file/d/1NsW4aZf8cAXaaUJLLpZB_2re4ijarx2H/view?usp=sharing
How about name search instead of reference no
Go ahead, and modify it, although, I have other video tutorials with name search on the channel for Excel
@@DJOamen Thank you so much for your kindness
Hi sir thank you for this video I like it so much please send me file
Check description
I Have just now paid channel membership fee for Rs 59 still no confirmation from your end?
No proof of your membership subscription
@@DJOamen provide me your email address i will share the bankers advice regarding the said payment
In my record, I still don't have your details. You can contact RUclips