Thanks everyone -- I apologize for my confusing post, especially th
last paragraph -- I must have been fairly tired.
There is definitely a "handshaking" problem between my main macro an
my Private code. Here is my Private code:
Private Sub grpCUT_OFF_LEVEL_Click()
End Sub
_________________________________________
Private Sub inptCUT_OFF_LEVEL_Change()
Dim MIN, MAX
Dim Str As String
MIN = ActiveCell.Offset(-4, 4).Value * 100
MAX = ActiveCell.Offset(-2, 4).Value * 100
Again:
Str = inptCUT_OFF_LEVEL.Value
Level = Val(Str)
'If Level = False Then Exit Sub
If Level MAX Or Level < MIN Then
MsgBox "Percentage must be between MIN and MAX"
GoTo Again
End If
MsgBox Level
End Sub
________________________________________________
Private Sub UserForm_Click()
End Sub
This is the relevant part of my main code:
frmCUT_OFF_LEVEL.Show
Range("PERCENT").Value = Level
PERCENT is a named cell in my WB.
First, things that are working:
By moving the cursor over the MIN and MAX variables when steppin
thru the Private code, I see the correct numbers. MsgBox Level i
displaying the correct number. That's the end of this list.
Things that are not working:
When the Form pops up, I am not able to input a number (th
Enabled Property is set to 'True'). What I was attempting to explai
in the last paragraph of my preceding post is that I would assign th
Value Property to the string "999"; when the Form popped up, I woul
scrape the rightmost 9 off the string with the BS key, then the macr
would continue stepping thru the Private code with the string "99" i
the text box. Keying the Enter key has zero affect on the text box.
Also, the Form does not 'go away' -- I have to click on the 'X' in th
upper right corner; I tried inserting "Unload Me" in the Private cod
for the Form itself, but that did not help.
Sharad,
I added a new module and inserted 'Public Level As Integer' in
macro by itself. This did not appear to change the above negativ
results.
Thanks again,
Chuckles12
--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...fo&userid=1494
View this thread:
http://www.excelforum.com/showthread.php?threadid=27744