VBA: Update worksheet when txtBox data changes.

[Mcasteel]

sounds like maybe you have an .offset line that is set incorrectly, o
maybe you can correct the situation by usinga cell.offset line.

hth

 

[Chuckles123]

Mike,

I have the following three lines of code for a command button ("OK") i
my UserForm:

Dim Str As String
Str = txtCUT_OFF_LEVEL.Value
Level = Val(Str)

and the following two lines of code in my "main" macro:

frmCUT_OFF_LEVEL.Show (Modal)
Range("PERCENT").Value = Level

where PERCENT is a named cell (variable row location) in my workbook.
In addition, I have "Public Level As Integer" in the same module as m
"main" macro but a separate procedure by its lonely self.

I think my "one cycle delayed" updating problem is due to my Propertie
not being correct for my textbox and/or my command button (less likel
to be the prob).

Chuckles12

 

[Chuckles123]

Mike,

Thru experimentation, I got it to work by deleting '(Modal)' in th
Show Form command.
Chuckles12