How can I update the userform?

  • Thread starter Thread starter Phillips
  • Start date Start date
P

Phillips

I have textbox1 to to offset(1,1) and textbox2 to offset(1,2)

I then have a button that moves textbox1 to Offset(1,3) & the currentvalue
of offset(1,3), and then Offset(1,2) is stuffed into offset(1,1) and then
offset(1,2) is stuffed with NULL.

Basically, Offset1,3 is a history of changes to offset1,1, and then I move
2, into 1.

In my userform, how do I refresh this?
I imagine I need to restuff the textboxes with the new values, but this does
not seem to be displayed on the screen.



Thanks
Phil
 
with worksheets("sheet1").Range("B9")
Textbox2.Value = .offset(1,2).Value
Textbox3.Value = .offset(1,1).Value
End With

is a possible guess.
 
Back
Top