refreshing sheet "under" modally shown useform

[mg25683]

Hi,

i have a modally shown userform. One of things it does is modifying cells in active sheet.
The changes are however not visible until i close it - even though application.screenupdating = on

Is there a way to see changes instantly?

- doEvents does not help
- showing uf modeless is not an option

thanks

[Paul_Hossler]

You didn't say how or how many cells it modifies

This seems to update the sheet as you type




Option Explicit


Private Sub TextBox1_Change()
ActiveSheet.Range("A1") = Me.TextBox1.Text
End Sub

[mg25683]

Ok, thank you for your help good sir, it is really that simple.
I simply had screenupdating = false, contrary to what i thought and was looking for some insane explanations of this phenomenon.

[royUK]

You can set the ControlSource of the TextBox to A1 then changes made to A1 will reflect in the TextBox, likewise changes made to the TextBox will change A1