Create a form to modify existing records
Solved/Closed
Related:
- Create a form to modify existing records
- Create skype account with gmail - Guide
- Create a yahoo email account for free - Guide
- Create snapchat account - Guide
- Wpan full form - Guide
- How to create viber group - Guide
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 06:14 AM
Jun 9, 2010 at 06:14 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Hi,
Here is the address https://authentification.site/files/22885672/Clients.xls
There is two problems:
1. I want the userform1 to be shown when the file clients open, the first thing the user woul see and everytime the user press the tab sheet1 the form pop up or open again.
2. I have two buttons, the add client and modify clients, I would want trough the modify clients button to change existing records of the clients in this case just the name of the client
Thanks and Thanks
Lucy
Here is the address https://authentification.site/files/22885672/Clients.xls
There is two problems:
1. I want the userform1 to be shown when the file clients open, the first thing the user woul see and everytime the user press the tab sheet1 the form pop up or open again.
2. I have two buttons, the add client and modify clients, I would want trough the modify clients button to change existing records of the clients in this case just the name of the client
Thanks and Thanks
Lucy
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 06:14 PM
Jun 9, 2010 at 06:14 PM
Ok for your first problem
Add this to ThisWorkbook (under excel objects in VBE)
AND
add this to Sheet1
For your #2
This is code in UserForm5, Changed lines are highlighted
Add this to ThisWorkbook (under excel objects in VBE)
Private Sub Workbook_Open()
UserForm1.Show
End Sub
AND
add this to Sheet1
Private Sub Worksheet_Activate()
UserForm1.Show
End Sub
For your #2
This is code in UserForm5, Changed lines are highlighted
Private Sub CommandButton1_Click()
Dim i As Integer
Dim final As Integer
For i = 2 To 1000
If Sheet20.Cells(i, 1) = "" Then
final = i - 1
Exit For
End If
Next
For i = 2 To final
If UserForm4.ComboBox1 = Sheet20.Cells(i, 1) Then
Sheet20.Cells(i, 1) = UserForm4.TextBox8
Exit For
End If
Next
UserForm4.ComboBox1 = ""
UserForm5.Hide
UserForm4.Hide
End Sub
Hi I do not know why is not working the code to modify the clients name
Help...
Help...
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 10, 2010 at 01:25 AM
Jun 10, 2010 at 01:25 AM
could you post the file with your updated code. and also could you give step by step process of update. please use example from the sheet
