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

Lowell In the south

Board Regular
Joined
Sep 26, 2002
Messages
55
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)?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
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

Board Regular
Joined
Sep 26, 2002
Messages
55
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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,029
Messages
5,835,036
Members
430,333
Latest member
jaypatel1298

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top