StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POVB Excel can't Copy and Paste Macro that Pulls the Cell Position
text
Body
copied!<p>I have a datasheet that looks like this</p> <p><strong>page 1</strong></p> <p>Costumer: josef</p> <p>Id: 12345</p> <p>I create a form that includes (Costumer and ID) more easily manually. Inside the form I have information.</p> <p>I have an insert button that delivery the information to specific cells inside the page.</p> <pre><code>Private Sub CommandButton1_Click() i = Cells(Rows.Count, 1).End(xlUp).Row + 23 'Get last empty cell in column A Range("D" & i).Value = TextBox1 'Range("D1").Value = TextBox1 Range("D2").Value = TextBox4 Range("C4").Value = TextBox2 Range("C5").Value = TextBox3 If OptionButton1.Value = True Then Range("A7").Value = OptionButton1.Caption ElseIf OptionButton2.Value = True Then Range("A7").Value = OptionButton2.Caption ElseIf OptionButton3.Value = True Then Range("A7").Value = OptionButton3.Caption Else Range("A7").Value = OptionButton4.Caption End If Unload Me End Sub </code></pre> <p>My problem is that I need to do the same in page 2 of the worksheet, when I copy and paste the macro to do the same in page 2, I need that values will be realease in the same position but in page 2, but the macro release the date in the same cells of the page 1, if you look the code I’ve set Value = TextBox1 to “D1, I need a formula that after copy macro and I invoked the form, It paste in the active sheet, Not on the first page like it does right now. Try placing a counter but that does not work. Any help will be appreciated.</p> <p>on this picture you will see sheet1 "hoja1" and page1 "pagina 1" and the load form (datos del presupuesto) <img src="https://i.stack.imgur.com/cziVj.png" alt="enter image description here"></p> <p>I also have picture 2 with sheet one but page 2 (pagina 2), in this page i copy and paste the same I have in page 1 (macro and everything) and i press insertar button to load the form, when the sistem insert it does it in the 1th page not in the 2 page.</p> <p><img src="https://i.stack.imgur.com/HfgqR.png" alt="enter image description here"></p> <p>It should be a formula that can help me when i copy one page and pastes the macros pull all the cell values to the page I am paste all the data.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload