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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,214,659
Messages
6,120,784
Members
448,992
Latest member
prabhuk279

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
Back
Top