vba/macro help

I want to record the info on Sheet One to Sheet Two after I click the Command Button to print out Sheet One. Only the info in the cells on Sheet One change not the cell positions. The recorded cell info on Sheet Two, however, should display on seperate rows with each click of the Command Button. Similar to example below. This is how 2 Command Button calls would appear on Sheet Two. The code shown below does not advance the rows on Sheet Two. Can you please help?

Thank you in advance for any assistance.

 

     A3   B3    C3

12:50:54 PM 001

$7.00

12:51:52 PM 002 $7.00

 

 

 

Private Sub CommandButton1_Click()

‘ Print_Ticket Macro

‘ Print Ticket

 

‘ Keyboard Shortcut: Ctrl+Shift+P

    Range(“A1:C6”).Select

    ExecuteExcel4Macro “PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)”

 

    Range(“B3”).Select

    ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 + 1

End Sub

By: James

444 thoughts on “vba/macro help

  1. 신분증위조

    Wow! This can be one particular of the most beneficial blogs We ave ever arrive across on this subject. Basically Great. I am also an expert in this topic therefore I can understand your hard work.

  2. Aplicativo Para Smart Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. cetak kotak sepatu

    Thanks regarding one marvelous posting! My partner and i enjoyed reading it; a person are a fantastic author. We will make sure to be able to bookmark your blog and even may come back at some point. I want to inspire that you continue the great posts, possess a saturday and sunday!

  4. SAP C_MDG_90 Exam

    Your style is really unique compared to other folks I have read stuff from. Thank you for posting when you ave got the opportunity, Guess I will just book mark this web site.

  5. aplikasi jualan online

    Your good knowledge and even kindness in using just about all the pieces were very helpful. I don’t know just what I could have done in case I had not came across such a step such as this.

  6. produksicetak

    My partner and i and my buddies were going by means of the nice, helpful suggestions through the blog then the particular sudden came up using an awful suspicion I actually never expressed respect for the website owner for all those secrets.

  7. Sedia Kendaraan

    Do an individual mind if I offer a couple of your own posts as long because I provide credit and even sources back to your own blog? My blog is usually in the same specific niche market as yours, and my personal users would benefit through some of the info you provide here. Make sure you let me know in case this ok with a person. Thank you.

Comments are closed.