Home
Excel VBA Examples
How To Do 
Software 
Sitemap Excel Userform - Address Book
I updated the userform that I did previously to run it in all version of Excel.
With this VBA userform ;
☑️ Data can be added
☑️ Data can be deleted
☑️ Data can be edited
☑️ Data can be searched on the sheet
☑️ Listbox can be filled and emptied with button.
☑️ Listbox can be scrolled with the spin button.
Id numbers are generated automatically when new record is added to the worksheet
and when record is removed.
The listbox is empty when the userform is opened.
The entered value in the searching box can be searched on the worksheet. Listbox are filled with the
found results .
The listbox column widths is automatically adjusted
according to the widths of the sheet's column with Vba codes.
Dear All
ReplyDeleteMy issue is that can we search multiple search in excel sheet in one click. Kindly guide : abuhafiz61@live.com
Can you explain?
DeleteDear Sir,
ReplyDeleteThis VBA also show values of hidden cells can you exclude that values. waiting for your reply
I could not fully understand
Deletehi sir can you please email me please jeanesky@yahoo.com I have an excel PROJET
DeleteI mean when we search then if suppose we have hidden the row then the search result also shows the values of hidden row.
ReplyDeleteHi ,
ReplyDeleteMay i know your email id, i need help for VBA.
kudreter@mynet.com
Deleteplease reach me @ b.ranjitbcom@gmail.com
ReplyDeletesir i have found your tutorial very useful and thats helps me in many ways thanks a lot. Now im having a new issue... how could i add 12 textboxes values to a listbox in a userform it only allowing me 10 textboxes. plz help me sir i couldn't go futher in this project at the moment
ReplyDeleteOk
Deletethank you very much sir........ looking for that tutorial........ i got stuck with this project at the moment....think you u will post it asap.....
DeleteOk , I am building it
DeleteTHANK YOU VERY MUCH SIR
DeleteI created new template :
DeleteThe Address Book (Userform's Listbox Contains 12 Column)
You can download it.
omgggg thank u very much sir it helps me a lottttttttt. i don't have words to say thanks because just thanks is not enough....
DeleteI don't know where am i making mistake when i take this code to my project. what am i trying is 12 textboxes value to listbox by click of a button and afterwards i click the button to transfer my listbox items to a closed worksheet. so is it possible sir to do that with ur new coding?
ReplyDeleteYou must make changes into codes.Have you examined this template : https://merkez-ihayat.blogspot.com.tr/2016/06/adding-data-into-closed-workbook-with.html
Deletethe link u has given is fine sir but the issue comes when i try to add 12textbox value to listbox because the 12textbox values going to be first added to listbox not to the worksheet. Afterwards i have another separate button to add listbox items to workbook. So first i need is how to add 12textbox values to listbox before data going to worksheet
DeleteTake a look at to new template :https://merkez-ihayat.blogspot.com/2016/09/excel-vba-copy-listbox-items-into.html
DeleteAWESOME TUTORIAL SIR U R SUCH A GENIUS... YOU HELPS ME ALOT THANK YOU SIR. FOR YOU KIND ATTENTION THIS TUTORIAL IS HELPING FOR MY SECOND PART OF THE PROJECT. BUT I NEED 12TEXTBOES TO LISTBOX WHERE I'VE STRUGGLING FOR NEARLY 1 MONTH. EARLIER YOUR TUTORIAL IS 12 COLUMNS FROM WORKSHEET TO LISTBOX. BUT I NEED 12TEXTBOXES TO LISTBOX SIR. CAN YOU HELP ME WITH THAT SIR PLZ?
DeleteI do not understand exactly what you want. How is "12 text boxes to listbox" ?
Deleteyes you are correct sir. 12 text boxes to listbox
Deletecan u help me with that sir?
DeleteI do not understand exactly what you want . Can you describe on a picture
Deletesure sir can u give me your mail id so that i can send u the picture sir.
Deletekudreter@mynet.com
Deletethank you very much sir i have sent u the pic and explained it also... hope u find it and reply me soon. Thanks for the support that u are giving to me sir........
Deleteok sir i have sent u the file also and mentioned the issues im facing. hope find it sir.
DeleteHello
ReplyDeleteI'm trying to download the file, but for some reason is not working.
Could you please send by mail: estevam.castelaro@hotmail.com
thank you
The template can be downloaded from Dropbox . To download the file does not need to be your dropbox account.You can press the "Direct Download" link for it.
DeleteI got it Sir, This tool is pretty amazing.
DeleteThank very much
Hello Sir
ReplyDeleteI want to use 2 VBA code as seen below in same one sheet, how can i do this , please advice !!
First Code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
FontSize = ActiveCell.Font.Size
LargeSize = FontSize * 1.6
Cells.Font.Size = FontSize
ActiveCell.Font.Size = LargeSize
End Sub
Second Code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str As String
On Error Resume Next
With Target
If .Count = 1 Then
str = .Address & "," & .Row & ":" & .Row _
& "," & Left(.Address, InStr(2, .Address, "$") - 1) & ":" _
& Left(.Address, InStr(2, .Address, "$") - 1)
End If
End With
Range(str).Select
On Error GoTo 0
End Sub
Try it :
DeletePrivate Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str As String,FontSize, LargeSize As Byte
On Error Resume Next
With Target
If .Count = 1 Then
str = .Address & "," & .Row & ":" & .Row _
& "," & Left(.Address, InStr(2, .Address, "$") - 1) & ":" _
& Left(.Address, InStr(2, .Address, "$") - 1)
End If
End With
Range(str).Select
FontSize = ActiveCell.Font.Size
LargeSize = FontSize * 1.6
Cells.Font.Size = FontSize
ActiveCell.Font.Size = LargeSize
End Sub
Thank You Sir for reply!!
ReplyDeleteI want to put date in Column A and want in same column as soon as date is entered it should give me number of days till date , how to make it possible through VBA Excel code
ReplyDeletethere are id numbers in column A.
DeleteNo their is date in column A, for e.g 10/09/2016 and i want number of days like 5 (days) till date.
ReplyDeleteI made an example file .Take look at this link :https://merkez-ihayat.blogspot.com/2016/09/excel-vba-calculating-days-between-two.html
DeleteSir, the link you provided that VBA code gives values in days in TextBox but i want in column A, please give me VBA code. Thank You
DeleteTake look at this link :https://merkez-ihayat.blogspot.com/2016/09/calculating-days-between-two-dates-2.html
DeleteSir
DeleteCan you give me code , i have not expert in excel VBA i am not able to fetch the code from this file. ( Date to days)
Did you download template ? If you downloaded template ,open it. Press Alt + F11 keys. Vba window is opened.You can view the codes there.
DeleteHai sir
ReplyDeleteI just to drop a very important question.how u hide the worksheet behind the userform ?? And how u add code for show sheet button. Please help me with this.
Tq
Thank you very much
Is there a sollution for allready?
DeleteSelam. Bi konuda yardımcı olurmusunuz?
ReplyDeletekindly send me this file anand.chaudhari@mail.com
ReplyDeletehy
ReplyDeletethank you for the form.
I've changed to adapt to my home library and add some columns to the listbox and now it has an error from which i can't get out. can you help me, please?
Dear Sir;
ReplyDeleteLet me thank you first for great job you had done here. sir hereby i am pleased to requesting to you for a program "Hotel reservation" with userforms.
Hope hear form you soon.
Thanks
Karim
HOW TO SHOW A HEADER IN LIST BOX.........?
ReplyDeleteHi Kadr. I'm having a run time error in this code:
ReplyDeletePrivate Sub txtSearch_Enter()
For a = 0 To 23
Controls("TextBox" & a + 1) = ""
Next
ListBox1.Clear
End Sub
I guess the reason is that my database contains ComboBox and DTPickers. How do I integrate the other control boxes? All lines containing the code Controls("TextBox" & a + 1) = "" are showing error messages.
Thank you.
Marcia
arreglen la descarga porfavor / fix the download please
ReplyDeletehi could you pls share a sample vba code, which should be able to search in list box and list box should populate only those rows where the search condition given through a text box in user form is true.
ReplyDelete