Make cells appear based off of an spin button or something similar

[aadams14]

Hi I was wondering if there is a vba code that would allow me to make this header appear every few lines dependent on an amount that varies from order to order.... header.png

maybe something that looks like this.... counter.png

If not vba, could you point me in the right direction to where on the forms i could ask?

Thank you,

Addie

[maniacb]

Can you provide a more thorough example. What you are asking for is not clear.

[aadams14]

I am trying to create a macros that essentially copy and pastes that header in this format dependent on what value is entered into the spin button. Does that make more sense? Sorry if I am being vague, I don't really know how else to explain it.

bigb bom.png

[maniacb]

So when the spin button value equals 3, you want the header to populate starting at row 3, and so on. It would help us if you could provide the actual file you are working with, see yellow banner above.

[aadams14]

No if the spin button value equals 3, I would like the header to populate 3 times every 15 lines, ext. This is a form for my company so I cannot post the original, but can post an excel with just the header in it.

[maniacb]

is the 15 lines constant

[aadams14]

is the 15 lines constant

Yes it is constant

[maniacb]

Here is code and a working file:

Please Login or Register  to view this content.

[aadams14]

Thank you so so much!!!!!

[aadams14]

Here is the excel attachment

[maniacb]

There is a conflict with the Worksheet_selectionchange on Sheet1, once I deactivated it, the other code works.

[maniacb]

Use this code for the Worksheet_selectionchange on Sheet1, Now the change is specific to the relevant cells, not the whole page.

Please Login or Register  to view this content.

[aadams14]

thank you, that worked very well

[aadams14]

Use this code for the Worksheet_selectionchange on Sheet1, Now the change is specific to the relevant cells, not the whole page.

Please Login or Register  to view this content.

Hey! I have another quick question about this same form and this code that enables/disables command button... For whatever reason the button does not enable unless I push the enter button after writing the engineer name in the I1. Is there a way for it to enable without having to push the enter key? I am going to reattach the file.

[aadams14]

Here is the file again...