computers are not logical
 

Hello everyone,

i am trying to get my VB code to put numbers into
textboxes....

what it does is checks the range and returns the value of
the cell.

for each cell it is to check if there is a value in the
textbox

if there is not then it inputs the value and moves onto
the next,

it will then check if this value is used already,

if it isnt then it will check if it is less than the first
textbox, if it is then it will move all the textboxes
contents down one (there are 6 textboxes a maximum of
six different values will be in range) and then put the
value in the according place

======================
logically this works!!!!
======================

my computer does not seem to do this, can anyone please
provide code that does the same??

textboxes 1,2,3,4,5,& 6
value to check is cell.offset(0,50) (cell has already been
set, and so has range)

Thankyou,

Robert Couchman