To offset or NOT to offset. That is the question. THEORY 10

[Lowell In the south]

I KNOW THESE ARE THE TYPE OF QUESTION PEOPLE DONT ANSWER BUT I NEED SUGGESTIONs ON A DIRECTION.

1. Can you use check boxes that hide/unhide text boxes. That the text boxes also some how move or be copied to the next available space in a row? If you had a range can you fill the top part of the range first then move to the next row down automaticaly (like a return on a typewriter)?

2. Can you place text in the next blank cell in a row skipping hidden columns? If you had a range can you fill the top part of the range first then move to the next row down automaticaly (like a return on a typewriter)?

 

[ChrisM]

I'll answer a few.

Yes, checkboxes can hide/unhide textboxes.

if checkbox(1) = true then
textbox(1).visible = true
end if

Yes you can move textboxes. Use the ones from the VB control box, they have left and top properties you can manipulate through code.

Yes you can fill ranges like a typewriter using offsets.

say your range is a 10 by 10 square. I'm doing this really fast, this code won't work, but here's the concept:

for i = 1 to 10
activecell.offset(i,0)
for i = 1 to 10
activecell.offset(0,i)
'do your horizontal code here
next i
'row done, moving to next row
next i

 

[Lowell In the south]

Thanks much!!!

How would you look for the first blank cell in a 10 x 10 range? To paste text? would it work the same way for a text box?