Hi,

bascially i've got one list box and next to that i have a tt reaso
box.
I've got vba to do the following:
If listbox = TT then ttreasonbox = inputbox("Please enter you
reason")

Is there anyway to get this, so that the TT reason box cannot be blank
So if TT is selected, there must be a reason in tt textbox?

Cheer

--
harpscardif
-----------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596
View this thread: http://www.excelforum.com/showthread.php?threadid=47878