VBA copy and paste data

[Paul Mullan]

Hi -

I have a spreadsheet that I am using as a database and a userform that I am using as the entry portal for the data being entered

I am trying to add some VBA to the userform that will copy data in columns A-C, but only from the last row of entered data. The VBA will run when button CommandButton1 is pressed.

Any help gratefully received

Paul

 

[GS]

Hi -

I have a spreadsheet that I am using as a database and a userform that I am using as the entry portal for the data being entered

I am trying to add some VBA to the userform that will copy data in columns A-C, but only from the last row of entered data. The VBA will run when button CommandButton1 is pressed.

Any help gratefully received

Paul

Spreadsheets being used as a database need to be properly structured as
datatables! Userforms being used as dataforms need to be properly
configured to work as a dataform! If you expect reliable performance and
integretyy from your project then 'willy-nilly', unfortunately, just
won't 'cut it'!

Can you post a download link to your project file so we can better
advise you and/or provide a solution? (Please make sure the file
contains some sample data, and a fully explained expectation of how you
want your dataform to work!)

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

I forgot to mention that Excel has a builtin dataform for exactly the
purpose of your userform! Did you try using that instead?

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion