Hello, I am trying to set up an order sheet and I am trying to figure out how to get a command button to do all the functions I want it to. So far I only have it inserting new line relative to the position of the command button.
I need 2 more parts to this code.
First, I need it to create a checkbox that says "RECEIVED" in column A of the new row that is inserted. the column width is 12.5, height is 20. I have gotten it to insert a checkbox, but not named and only in the same location. I haven't figured out how to make it relative to my command button.
Second, I need a formula that will autonumber sets of rows continously down the worksheet. ie. section 1; Hardware, line number: 1, 2, 3, 4, 5, 6, 7... skip a couple lines2; Lights, continued; 8, 9, 10, 11. But I need the code to update the lines lower down if a new row is inserted using the command button. (there is a command button 2 rows high between each section, along with 2 rows of titles and labels) is this possible?
Thanks,
Tanner
Code:
Private Sub CommandButton2_Click()
CommandButton2.TopLeftCell.Rows.EntireRow.Insert
End SubI need 2 more parts to this code.
First, I need it to create a checkbox that says "RECEIVED" in column A of the new row that is inserted. the column width is 12.5, height is 20. I have gotten it to insert a checkbox, but not named and only in the same location. I haven't figured out how to make it relative to my command button.
Second, I need a formula that will autonumber sets of rows continously down the worksheet. ie. section 1; Hardware, line number: 1, 2, 3, 4, 5, 6, 7... skip a couple lines2; Lights, continued; 8, 9, 10, 11. But I need the code to update the lines lower down if a new row is inserted using the command button. (there is a command button 2 rows high between each section, along with 2 rows of titles and labels) is this possible?
Thanks,
Tanner
