Auto add rows to bottom when checkbox filled

%3CLINGO-SUB%20id%3D%22lingo-sub-1892417%22%20slang%3D%22en-US%22%3EAuto%20add%20rows%20to%20bottom%20when%20checkbox%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1892417%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20create%20a%20more%20simplified%20form.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETop%20of%20form%20would%20be%20on%20every%20form.%26nbsp%3B%20(name%2C%20address%2C%20phone%2C%20ect)%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20would%20like%20a%20row%20with%20a%20checkbox's.%20or%20buttons%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20checkbox%20is%20ticked%2C%20I%20would%20like%20it%20to%20auto%20add%20the%20relevant%20rows%20I%20have%20in%20a%20separate%20tab%20in%20the%20same%20workbook%20(if%20checked%2C%20insert%20rows%203-10%20of%20%22sheet%202%22%20for%20example)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3EBuilder%20info%20and%20unit%20info%20boxes%20always%20at%20top%3C%2FP%3E%3CP%3EIf%20customer%20picks%20ceramic%2C%20Tick%20checkbox%20and%20have%20it%20add%20the%20ceramic%20rows%3C%2FP%3E%3CP%3Esame%20for%20any%20subsequent%20%22Trades%22%20that%20need%20to%20be%20added.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20way%2C%20if%20its%20only%20one%20trade%2C%20the%20form%20wouldn't%20take%20any%20space%20for%20the%20%22hw%22%20or%20%22cpt%22%20unless%20those%20boxes%20were%20selected%20on%20the%20main%20form%20section%20to%20the%20top.%20Currently%20I%20have%20it%20set%20up%20as%20%22Group%20rows%22%20which%20places%20a%20plus%20sign.%26nbsp%3B%20This%20requires%20I%20leave%20a%20row%20showing%20in%20order%20to%20label%20the%20hidden%20rows%20for%20others%20who%20access%20the%20form.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%20Not%20great%20at%20macro%2FVB%20yet.%26nbsp%3B%20In%20the%20attached%2C%20the%20first%20tab%20is%20my%20current%20form.%20Tab%202%20has%20the%20row%20with%20spots%20for%20checkboxes.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1892417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Trying to create a more simplified form. 

 

Top of form would be on every form.  (name, address, phone, ect) 

Then I would like a row with a checkbox's. or buttons 

If the checkbox is ticked, I would like it to auto add the relevant rows I have in a separate tab in the same workbook (if checked, insert rows 3-10 of "sheet 2" for example) 

 

For example: 

Builder info and unit info boxes always at top

If customer picks ceramic, Tick checkbox and have it add the ceramic rows

same for any subsequent "Trades" that need to be added. 

 

This way, if its only one trade, the form wouldn't take any space for the "hw" or "cpt" unless those boxes were selected on the main form section to the top. Currently I have it set up as "Group rows" which places a plus sign.  This requires I leave a row showing in order to label the hidden rows for others who access the form. 

 

Any ideas? Not great at macro/VB yet.  In the attached, the first tab is my current form. Tab 2 has the row with spots for checkboxes. 

 

 

 

 

1 Reply
Highlighted

@TYMAN1333 

 

* Knowledge of Excel version and the operating system are a must if you want to get a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).

 

In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)