Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2021, 05:43 AM
Will267 Will267 is offline Copy and paste function for Command Button Windows 10 Copy and paste function for Command Button Office 2019
Novice
Copy and paste function for Command Button
 
Join Date: May 2021
Posts: 1
Will267 is on a distinguished road
Default Copy and paste function for Command Button

Hi all



I am after some much needed help!

I am creating a form which will allow a number of different users the ability to open the document and then update the form with their weeks worth of work. At the end of the week the form can be collated and analysed by supervisors.

The form consists of a simple table which i with to restrict to ensure there is no editing of the table.

I want to add a 'Add new entry' command button which will allow a user to simply click and it will copy the above table and insert it below. Allowing all previous entries to remain and simply add a new table below ready for the member of staff to complete.

They will simply save the document and someone else can open it when they have completed some more new work.

I believe i can do this with a Macro however i can't get the macro to work or be able to assign it ot the button

Any help will be appreciated

Thanks all
Reply With Quote
  #2  
Old 05-12-2021, 02:31 PM
macropod's Avatar
macropod macropod is offline Copy and paste function for Command Button Windows 10 Copy and paste function for Command Button Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example:
https://www.msofficeforums.com/word-...html#post87989
https://www.msofficeforums.com/word-...html#post38461
https://www.msofficeforums.com/word-...tml#post145675
Some additional code could be used to protect the content already there when a new row is added.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and paste function for Command Button Replicate the copy/paste function, without involving the clipboard alex100 Word VBA 8 11-09-2020 08:19 AM
Command button. To multi command Taylormations Word VBA 11 09-14-2020 02:39 AM
Show table list by using chek box command and save document on sharepoint by using command button Zhibek Word VBA 3 08-16-2018 06:19 PM
Copy and paste function for Command Button Disable email function of command button if all form fields are not completed derajlance Word VBA 10 05-11-2016 01:05 PM
Copy and paste function for Command Button Word VBA: How to create a command button and trigger a function? tinfanide Word VBA 2 12-02-2011 05:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft