VBA: Update worksheet when txtBox data changes.
 

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

hth
M


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=274237

Mike,

I have the following three lines of code for a command button ("OK") in
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 my
"main" macro but a separate procedure by its lonely self.

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

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=274237

Mike,

Thru experimentation, I got it to work by deleting '(Modal)' in the
Show Form command. :)
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=274237