Hi All,

I have a userform with 7 textboxes

Textbox7 = (Textbox1+Textbox2) - (textbox3+textbox4+textbox5+textbox6)

Is it possible to imitate a goal seek on textbox7 by changing textbox1
or 2 or 3.... etc by saying which textbox value to change?


How i can make an easy code for this?

Thanks

Soniya,

Why do you want to replicate GOAL SEEK? For sure, your end-product
should you succeed, will be less efficient and slow.

myles





Soniya Wrote:
Hi All,

I have a userform with 7 textboxes

Textbox7 = (Textbox1+Textbox2) - (textbox3+textbox4+textbox5+textbox6)

Is it possible to imitate a goal seek on textbox7 by changing textbox1
or 2 or 3.... etc by saying which textbox value to change?


How i can make an easy code for this?

Thank

--
Myle
-----------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874
View this thread: http://www.excelforum.com/showthread.php?threadid=57350