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