LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default how to update a record from combo-box in user form?

hello guys.
i really need some help with that thing.
im newbie in vba but rally like all that stuff.

i have this table:

and i have a form for a user

that i want he can update the table like this:
the user choose a name from the "worker name" combo-box
and when he click on "update" so the "yes/no" column in the table will show "yes" for the name that was chosen by the user.

second thing is that
when the user choose a name and click on the empty button, so it will delete all the record of the name was chosen (all the row).
this is the code of the form so far

Private Sub cmdAdd_Click()
Dim lRow As Long
Dim ws As Worksheet
Set ws = Worksheets("workers")

'בדיקה אם הוכנסו פרטים
If Trim(Me.cmbWN.Value) = "" Then
Me.cmbWN.SetFocus
MsgBox "הכנס שם עובד"
Exit Sub
End If

If Trim(Me.tbDate.Value) = "" Then
Me.tbDate.SetFocus
MsgBox "הכנס תאריך בחינה"
Exit Sub
End If

ActiveWorkbook.Save
End Sub

Private Sub tbDate_Change()

End Sub

Private Sub UserForm_Initialize()
Dim cFullName As Range

Dim ws As Worksheet
Set ws = Worksheets("workers")

For Each cFullName In ws.Range("שםפרטי")
With Me.cmbWN
.AddItem cFullName.Value
.List(.ListCount - 1, 1) = cFullName.Offset(0, 1).Value
End With
Next cFullName

tbDate.Text = Sheets("not done").Range("J3").Text
End Sub
thank for all helpers
Attached Images
  
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
record update VBA form Roy Gudgeon[_2_] Excel Discussion (Misc queries) 0 March 15th 10 04:27 PM
User form combo box anon Excel Programming 0 April 12th 08 02:03 PM
User form - Get record & Edit Data Matts Excel Programming 0 November 19th 07 04:00 PM
Cant get a combo box to update without closing form justin Excel Discussion (Misc queries) 0 May 17th 06 09:06 PM
Move to Next Record with User Form CindyK Excel Programming 2 November 5th 04 05:40 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"