Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform to show and update data problem | Excel Programming | |||
VBA userform troubles... adding to database no problem....updating modifying info = :( | Excel Programming | |||
problem getting data from sheet into txt_boxes in userform | Excel Programming | |||
Userform updating | Excel Programming | |||
Excel VBA - Updating of data problem | Excel Programming |