Hello All!! ;)

I have created a small VB program in excel to calculate a number base
on about 5-6 given numerical inputs. This program also use
IF...Then....ElseIf logic by taking some of the inputs and based on th
values, routing the inputs to different equation sets for calculation
Anyway, I have setup two ways for Excel to calculate the correc
output: one, is by pushing a button that prompts each numeric input i
an application box and second, by inputting the values into the correc
cells manually and then clicking on the output text box (the code i
based off of the "GotFocus" feature for the textbox). However, here i
the problem!! When the user inputs using the button method everythin
works fine. However, when inputting using the manual method into eac
cell and then clicking on the textbox, the screen starts to rapidl
blink over and over again and will not stop until the user click
somewhere else on the screen. The program then spits out the value int
the textbox. The answer is right but this is dreadfully annoying. *DOE
ANYONE KNOW HOW TO KEEP THIS BLINKING FROM HAPPENING?

--
gunma
-----------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...fo&userid=2399
View this thread: http://www.excelforum.com/showthread.php?threadid=37614