re-entering userform

  • Thread starter Thread starter Rune_Daub
  • Start date Start date
R

Rune_Daub

I made a small script where I can search and change information based o
rows.
Say I got 200 rows of information that each contains 20 columns.
That would be unberable to look at, so I made a seach function in
userform and a button that opens up another userform that loads th
information of the row that the search result gives. A little lik
Data>Form with text boxes that each load a specific cell in a row.
It works fine for the first set of data I open up.
If I repeat the search for a new set of data that I want to load in th
userform, it just loads the First set of data instead.

I hope I make myself clear.. The code I been using to load the data i
the userform is this.


-----------------------
Private Sub UserForm_Initialize()

Range("A" & ActiveCell.Row).Activate

tboPhone.Value = ActiveCell.Offset(0, 0).Value
tboName.Value = ActiveCell.Offset(0, 1).Value
tboStreet.Value = ActiveCell.Offset(0, 2).Value

End Sub
 
do you unload the form rather than hide it. The initialize event only runs
when you first create the form. If you hide and then show the form, it is
not created and the initialize event is not run.
 
Thx... that would probably solve my problem.. I have just been hiding
it... I will try with the unload function :)
 
Back
Top