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)?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,396
Members
414,235
Latest member
sucosama

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