View Single Post
  #2   Report Post  
Chuckles123
 
Posts: n/a
Default


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