View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre[_18_] Pierre[_18_] is offline
external usenet poster
 
Posts: 19
Default Help !, problem updating data through userform !

Hi,

I have a multipage on a userform.
On the multipage i have an number of textboxes (20).
The contect of the textbox is looked up in a databasesheet ("datadga")
through this code;

Private Sub but_ophalen_Click()
Dim klantkeuze As String
klantkeuze = zoekwg.Value
Set klantmatrix = Worksheets("datadga").Range("B2:b500").Find(klantk euze)
txt_naamwg = Worksheets("datadga").Cells(klantmatrix.Row,
klantmatrix.Column)
txt_dganaam = Worksheets("datadga").Cells(klantmatrix.Row,
klantmatrix.Column + 1)

whe
klantkeuze is the result from a combobox called "zoekwg"

What is the problem ?
When the data is shown in the textboxes, i can overwrite it, but it will not
be written in the database sheet.
I know that, if you use controlsource, it will be overwritten, but in this
ase, bacause the data is pciked out of a database, i do not know how i can
get de database updated if someone changes de content of one of the
textboxes

Can anyone please help ?
Thanks,
Pierre